First Day of Next or Previous Month in Excel (Excel Function EOMONTH)

Now determining last day of the month is easy in excel. It can be determined by function EOMONTH

Syntax

EOMONTH(any_date,months)


Formula

For last day of month                            =EOMONTH (any_date,0)

For last day of next month                     =EOMONTH (any_date,1)

For last day of previous month               =EOMONTH (any_date,-1)

By changing second argument in function we can get last day of any month.