EDATE

Adds or subtracts a specified number of months from a date.

Syntax:

=EDATE(start_date,months)

Example:

=EDATE(A2,3)

If A2 = 28-Sep-2026:

Result: 28-Dec-2026

To go three months backward:

=EDATE(A2,-3)

EOMONTH

Returns the last day of a month.

Syntax:

=EOMONTH(start_date,months)

Example:

=EOMONTH(A2,0)

If A2 = 28-Sep-2026:

Result: 30-Sep-2026

Next month’s end:

=EOMONTH(A2,1)

Result: 31-Oct-2026

EDATE vs EOMONTH

EDATE

EOMONTH

Moves a date by months

Returns month-end date

Example: 28-Dec-2026

Example: 30-Sep-2026
PreviousNext