Author: Oscar Cronquist Article last updated on May 09, 2022

The EOMONTH function returns an Excel date for the last day of a given month using a number and a start date.

Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

Formula in cell C3:

=EOMONTH(B3)

Excel Function Syntax

EOMONTH(start_date, months)

Arguments

start_date Required. A date that represents the starting date. Don't use text dates, use Excel dates, see comments below.
months Required. A number that determines how many months before or after the start date. A negative value returns a date earlier than the start_date.

Comments

Excel dates are actually numbers formatted as dates. January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.

The DATE function allows you to return an Excel date in the EOMONTH function. =EOMONTH(DATE(2008,1,1),2) returns 3/31/2008.

Excel 'Date' functions


DATE function
Returns a number that acts as a date in the Excel environment.
DATEDIF function
Returns the number of days, months, or years between two dates. The DATEDIF function exists in order to ensure compatibility with Louts 1-2-3.
DATEVALUE function
Returns an Excel date value (serial number) based on a date stored as text.
DAY function
Extracts the day as a number from an Excel date.
DAYS function
Calculates the number of days between two dates.
EDATE function
Returns a date determined by a start date and a number representing how many months.
EOMONTH function
Returns an Excel date for the last day of a given month using a number and a start date.
MONTH function
Extracts the month as a number from an Excel date.
NETWORKDAYS function
Returns the number of working days between two dates, excluding weekends. It also allows you to ignore a list of holiday dates that you can specify.
TODAY function
Returns the Excel date (serial number) of the current date.
WORKDAY function
Returns a date based on a start date and a given number of working days (nonweekend and nonholidays).
YEAR function
Converts a date to a number representing the year in the date.
YEARFRAC function
Returns the fraction of the year based on the number of whole days between a start date and an end date.
Excel Function Reference
Provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas.