EDATE Function

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

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

=EDATE(start_date,months)

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

Excel EDATE

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