Excel > Functions

EOMONTH Function

The Excel EOMONTH function calculates the last day of the month a specified number of months before or after a date.

EOMONTH is often used to calculate the due date for an investment that falls on the last day of a month.

The syntax for the EOMONTH function is:

=EOMONTH(start_date, months)

Argument

Purpose

Start_date

The date representing the start date

Months

The number of months before or after the start date. Enter the number as a negative for months before

The examples below demonstrate the EOMONTH function being used to calculate the last day of the month a specified number of months before and after the date in the spreadsheet.

Date to be used in the Excel EOMONTH function

Function

Result

=EOMONTH(A2, 3)

30/06/2010

=EOMONTH(A2, 0)

31/03/2010

=EOMONTH(A2, -2)

31/01/2010

Follow us on

Facebook  Twitter  You Tube 

Other Date & Time Functions

Excel 2010 Superhero Course