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 Reply

Autofilter in Excel

AutoFilter Excel offers an easy way to search or modify complex data sets using the AutoFilter feature. In order to

Read More »
Scroll to Top