EOMONTH Function in Excel

Arguments

start_date

Required

A date that represents the starting date. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text .

months

Required

The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date. Note: If months is not an integer, it is truncated.

What EOMONTH does

EOMONTH jumps to the last calendar day of a month relative to a start date. It is especially useful for month-end reporting, billing cycles, and deadline formulas.

Practical examples

Get the end of next month

=EOMONTH(A2,1)

If A2 contains 2026-03-19, the result is the last day of April 2026.

Get the end of a prior month

=EOMONTH(A2,-3)

This is useful for rolling period logic such as quarter-end or prior-month close.

Common mistakes and notes

EOMONTH returns the month end, not the same day number

If the start date is March 19, the result is not June 19 or December 19. It is always the final day of the target month.

Non-integer month offsets are truncated

If the months argument is not a whole number, Excel truncates it. Use integers when building schedules.

Format the result as a date

Like other date functions, EOMONTH returns a serial value. Apply a date format if the result shows as a number.