Add/Subtract Months in Excel (EDATE Function)

Hey Buddies... Now I will teach you how to add or subtract months in a date and determine project start date or end date or investment due date. This can be achieved using Excel function EDATE.

Syntax

= EDATE ( Start_date , Months )


Calculate Investment Due Date

Now consider your investment has started from 13- Aug 2013 and you have to pay next due after 6 months then this date in excel can be calculated as follows

Start_date: 13-Aug-2013
Payment_freq: 6

Due Date = EDATE (Start_date, Payment_freq)

Due Date = 13-Feb-2014


Calculate Project Start Date

Consider you have target of ending a specific project on 15-Jun-2014 and project will take 3 months to complete. Then when should one start the project. EDATE function can be used to meet this requirement.

End_date: 15-Jun-2014
Project_tenure: 3


Due Date = EDATE (End_date, - Project_tenure)

Due Date = 15-Mar-2014


If you like this post or any other post on this page then please share our blog with your friends via emails or social sites. Thanks. Please support us.