How to Use EOMONTH Function

EOMONTH function returns the last day of the month before or after the specified months.


=EOMONTH(start_date, months)


  • Start_date is required, the start date you need to have the date months before or after.
  • Months is required, the number of months you specified.


  • Dates are stored as sequential serial numbers and January 1, 1900 is serial number 1.
  • When month is not an integer, it is truncated to use the integer.

Download: EOMONTH Function

Leave a Reply