Excel EOMONTH() Function
Excel EOMONTH() Function
The EOMONTH() function in excel returns the serial number of the last day of the month before or after a specified number of months.
Syntax
EOMONTH (Start_Date, Month)
Parameter
Start_Date(required)- This parameter represents the date from which you calculate the before and after the date.
Month(required)- This parameter represents the month in numeric format.
Category
Date & Time
Return
This function returns the serial number of a particular date.
Example 1
Objective: Find the last date of the month for the date
Value | Result | Formula |
11/15/2016 | 30-Nov-16 | =EOMONTH(A12,0) |
Example 2
Objective: Return the last day of the next month
Value | Result | Formula |
3/7/2018 | 31-Dec-19 | =EOMONTH(TODAY(),1) |
Example 3
Objective: Return the first day of the current month
Value | Result | Formula |
3/7/2018 | 1-Nov-19 | =EOMONTH(TODAY(),-1)+1 |