Thursday 16 October 2014

Excel EDATE Function

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

No comments:

Post a Comment