From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Calculating end-of-month and future and past dates with EDATE and EOMONTH

Calculating end-of-month and future and past dates with EDATE and EOMONTH

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

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…

Contents