EOMONTH

Get the last day of the month in future or past months

Sponsored Link

EOMONTH

Purpose 

Get the last day of the month in future or past months

Return value 

A serial number that represents a particular date in Excel.

Syntax 

=EOMONTH (start_date, months)

Arguments 

  • start_date - A date that represents the start date in a valid Excel serial number format.
  • months - The number of months before or after start_date.

Usage notes 

For months, use a positive value for future dates and a negative value for dates in the past.

If you receive a #NAME? error when trying to use this function, install and load the Analysis ToolPak add-in.

Sponsored Link

0 votes. 0 / 5