How can I add months to a date in excel

Asked By Gene C Silva 130 points N/A Posted on - 02/16/2015

How can I add months to a date in excel? I am unable to add months to a date in excel. Do you have any suggestions how can I do this?

• Status: Open
• Question Views: 773
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others

Answered By Intestar Linne 0 points N/A #186043

How can I add months to a date in excel

Actually, the EDATE formula or function is a part of Toolpak of Excel Analysis that should be installed to use this. In order to install, go to Tools, then Add-ins, finally check the Analysis Toolpak. You can use this EDATE function like the following example to take or add 1 month to this date in the A1 including the date(31-OCT-2004). It will be:

=EDATE(A1,1)

As a result, this formula will yield the result of 30-NOV-2005. And Not the date 31-NOV-2004, because this date doesn't exist.

And to take one month from this date, we can use:

=EDATE(A1,-1)

As a result, this formula will yield the result of 30-SEP-2004.
Hopefully, this answer is helpful, easier and clearer steps to fix the problem.

About Intestar Linne

Questions
0

Answers
48

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 02/16/2015
• Question Category: Software Others