Menu
EXCEL EOMONTH FUNCTION
Excel EOMONTH Function Introduction
The EOMONTH Function is classified as a DATE/TIME function. After adding a specified number of months to a date, the function calculates the final day of the month.
Description of Excel EOMONTH Function
Syntax:
=EOMONTH(start_date, months)
Parameters:
- Start date (mandatory parameter) – This is the first date. Dates must be entered in date format, either via the DATE function or as the output of other formulae or functions. For May 13, 2017, for example, use DATE(2017,5,13). If dates are supplied as text, this method will return errors.
- Months (mandatory parameter) – This is the number of months preceding or after the start date. A positive number for months results in a future date, whereas a negative value results in a past date.
Step By Step Guide of EOMONTH Function
Example :
- In Row 2, the function multiplied 9 by the final day of December (9+3).
- The code in Row 3 removed 9 to return July 31, 2015.
- In Row 4, the function merely returned January 31, 2017. In Row 5, the method added 12 months and returned the final day of January.
- In Row 6, we used the function TODAY, thus EOMONTH evaluated the date as of today, November 18, 2017, and added 9 months to it to return August 31, 2018.
Key Points
Please remember that the EOMONTH function will give a serial date value. A serial date is how Excel maintains dates internally, and it reflects the number of days from January 1, 1900.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORK DAYS Function
Explore Now
