Welcome back
Today we have a very important function of time and date functions
in Excel
EOMONTH Function
This article describes the formula syntax and usage of the EMONTH function in Microsoft Excel.
Function Description
This function returns the serial number for the last day of the
month which is the indicated number of months before or after the start_date.
Use the EOMONTH function to calculate payment dates or due dates that fall on
the last day of the month.
Syntax :
EMONTH(start_date, months)
Start_date : is required. Date represents the start date.
Dates must be entered using the DATE function, or as results of other formulas
or functions. For example, use DATE(2008,5,23) for the 23rd of May 2008. Some
problems may occur if dates are entered as text.
Months : are required. The number of months before or
after the start_date. A positive value for months indicates a future date,
while a negative value indicates an earlier date.
Very important note:
If the number of months is not an integer, it is truncated.
One of the most important notes
It is known that Microsoft Excel stores dates as consecutive
sequential numbers so that they can be used in arithmetic operations. By
default, 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.
If start_date is not a valid date, EOMONTH returns #NUM! It is an
error value.
If start_date plus months indicates an invalid date, EOMONTH
returns #NUM! .