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  



ADVERTISEMENT
ADVERTISEMENT