How to get the last day of any Future or past months In Excel | How To Use Eomonth Function In Excel
EOMONTH ()
The Excel EOMONTH function returns the last day of the month,
n months in the past or future.
You can use EDATE to calculate expiration dates, due dates, and other dates
that need to land on the last day of a month.
Use a positive value for months to move forward in time, and a negative number to move back in time.
Purpose
Get last day of month n months in future or past
Return value
Last day of month date
Syntax
=EOMONTH (start_date, months)
Arguments
start_date - A date that represents the start date in a valid Excel serial number format.
months - The number of months before or after start_date.
The EOMONTH function returns the last day of the month a given number
of months in the past or future.
You can use EOMONTH to calculate expiration dates, due dates,
and other dates that need to land on the last day of a month.
The EOMONTH function takes two arguments: start_date and months.
Start_date must be a valid Excel date.
The months argument specifies how many months in the future or
past to move – use a positive number to move forward in time,
and a negative number to move back in time.
EOMONTH returns a serial number corresponding to an Excel date.
To display the result as a date, apply a number format of your choice.
You can follow us on the below social media handles:-
Blog: - https://thedatamillennials.blogspot.com/
Facebook:- / the-data-millennials-596575371027542
Instagram: - / the_data_millennials
LinkedIn: - / data-millennials-6b5a031b3
Twitter: - / datamillennials