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.”
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.
Usage Errors
If the result cell is not formatted as a date, the returned value will be a serial date.
