How can I add months to a date in excel

Asked By 130 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #186043

How can I add months to a date in excel

qa-featured

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.

Related Questions