The EOMONTH function in Excel that calculates the last day of the month after adding a specified number of dates. EO stands for “End of Month.”

Syntax:

  =EOMONTH(start_date, months) 

Arguments

  • start_date – (required) Must be valid starting date
  • months – (required)

EOMONTH Function in Excel Usage Example:

Review the examples below. For the date 6/5/2019, we want to add 6 months. Excel returns the date of 12/31/2019. The same calculation is done for the rest of the dates.

EOMONTH Function

Usage Errors

If the result cell is not formatted as a date, the returned value will be a serial date.