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


You can use Randbetween random Number Generation for a number or purposes in Excel. The Excel RANDBETWEEN function returns a

Read More »

SUMIFS Function

The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to

Read More »


The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date,

Read More »
Scroll to Top