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)

 The syntax of the EMONTH function has the following two arguments:

 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! .

Related Articles

Sumproduct Function In excel 

Convert function

Emad ghazi
كاتب المقالة
كاتب ومحرر اخبار اعمل في موقع عالم الاوفيس .

جديد قسم : دوال الاكسل

إرسال تعليق