How to get same date next month or previous month in Excel

by

To get the same date next month from a given date, you can use the EDATE function.

Formula

=EDATE(date,1)

Explanation

In the example shown, the formula in cell B5 is:

Worked Example:   How to calculate future date say 6 months ahead in Excel
=EDATE(B5,1)

How this formula works

EDATE can get the “same date” in the future or past, based on the number of months supplied. When 1 is given for months, EDATE gets the same date next month.

Worked Example:   How to calculate next anniversary date or birthday in Excel

Same date in previous month

To get the same date in a previous month, use -1:

=EDATE(date,-1) // prior month

 

Worked Example:   How to get same date next year or previous year in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *