From the course: Excel 2016: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Calculating end-of-month and future and past dates with EDATE and EOMONTH
From the course: Excel 2016: Advanced Formulas and Functions
Calculating end-of-month and future and past dates with EDATE and EOMONTH
- If you're trying to calculate differences across months and if you need to measure time in months, two functions: EDATE and EOMONTH, might be of use. In column A, we've got some employee IDs, a starting date, and depending upon the role in the organization the person has, there's a different probationary period. So based on the starting date, we want to know when the probationary period ends and each probationary period is stated in months. So three months after, for example, May 28th, will be August 28th. But if we add 30 or 31, something like that, we're not going to get the correct answers consistently, so let's use the function called EDATE. We've got a starting date, it's in cell B2, it's May 28th. Comma, number of months later: three, and we get August 28th. And we can do this for the entire column; we'll double-click. Notice when you've got a date like October 30th and you add four months, it would end up at February 30th, but, of course, there is no such day, so Excel…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
(Locked)
Understanding Excel date and time capabilities in formulas9m 52s
-
(Locked)
Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions4m 4s
-
(Locked)
Using the TODAY and NOW functions for dynamic date and time entry6m 49s
-
(Locked)
Identifying the day of the week with the WEEKDAY function4m 40s
-
(Locked)
Counting working days with the NETWORKDAYS function5m 26s
-
(Locked)
Determining a completion date with the WORKDAY function4m 10s
-
(Locked)
Tabulating date differences with the DATEDIF function6m 15s
-
(Locked)
Calculating end-of-month and future and past dates with EDATE and EOMONTH4m 58s
-
(Locked)
-
-
-
-
-