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. 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