EOMONTH Function Explained

The EOMONTH Function in Microsoft Excel returns the last day of the month that is a specified number of months before or after a given date. It takes two arguments: the start date and the number of months before or after the start date. The result is always the last day of the month.

EOMONTH Function Syntax

EOMONTH(start_date, months)

  • start_date: The start date from which the number of months is added.
  • months: The number of months to add to the start date.