EDATE

Shifts a date forward or back by a whole number of months and keeps the same day number, so =EDATE(E5,2) moves 15 December 2024 to 15 February 2025. A negative number goes backwards.

When to use

Use it to add months to a date; it is better than adding 60 days because months have different lengths.

See Lec 04.

Appears in

No references yet.