EOMONTH Function in Excel

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


  =EOMONTH(start_date, months) 


  • 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.

Leave a Comment

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

Scroll to Top
Send this to a friend