EDATE Function

Microsoft training delivered by certified trainers, and a microsoft partner training company
excel training Excel EDATE Function Explained

To calculate due dates for projects or payments then Excel’s EDATE function will make life easier for you.
Excel’s EDATE function is ideal for:

  • calculating when a payment is due or project is to be completed
  • calculating the date a scheduled number of months in the past or into the future

Excel EDATE Function Syntax


Returns the serial number of the date that is the indicated number of months before or after the start date.


Calculate Date from Today

3 Months from today: =EDATE(NOW(),3)

3 Months prior to today: =EDATE(NOW(),-3)

Note: if the date displays as a serial number simply change the formatting to a Date format. CTRL+1 to open formatting dialog box

Excel can be fun try out some of its features Detailed on this Site


Mike Barrett (MCT) Senior Training Advisor