EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel

The following article introduces you to the EOMONTH function - one of the functions in the date and time group function is very popular in Excel.

EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel Picture 1

Description: The function performs the calculation and returns the last day in the month before or after 1 day of a specified number of months.

Syntax: EOMONTH (start_date, months)

Inside:

- start_date: The date represents the start date to calculate the last day of one or more months before or after, is a required parameter.

- months: Number of months you want to calculate, is the required parameters with the following cases:

+ months> 0 -> Create new days in the future.

+ months <0 -> Create new date in the past.

Attention:

- Excel stores the date as a serial number to facilitate the calculation process.

- If the start_date value is not a valid date -> the function returns the #VALUE! Error value

- Where start_date plus moths create an invalid date -> the function returns the #NUM! Error value

For example:

Calculate the last day in the month before or after a specific number of months in the table below:

EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel Picture 2

- In the cell to calculate enter the formula: = EOMONTH (E7, F7).

EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel Picture 3

- Press Enter -> the last day of the month before 1/1/2011 1 month is:

EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel Picture 4

- Similarly copy the formula with the same value but the opposite month argument results. So with months <0 in the past:

EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel Picture 5

- Copy the formula for the remaining values ​​to get the result:

EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel Picture 6

- Where the value of months is not an integer -> it is truncated to an integer:

EOMONTH function - The function returns the last day in the month before or after 1 day of a specified number of months in Excel Picture 7

Above are instructions and some specific examples when working with EOMONTH function in Excel.

Good luck!