Date & Timebeginner
Get the last day of a month with EOMONTH
=EOMONTH(A2,0)
Google Sheets reference
EOMONTH in Google Sheets
Works in Google Sheets1 worked example
Worked examples (1)
These formulas work in Google Sheets with identical syntax.
Also in Excel
See the full EOMONTH reference for Excel — including all worked examples, common errors, and FAQ.
EOMONTH Excel reference →