Function reference

EOMONTH in Excel & Google Sheets

EOMONTH is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.

1 beginnerBuild a custom EOMONTH formula →

When to use EOMONTH

Set billing period end dates, calculate quarter-end dates, or find the last day of any month without knowing whether it has 28, 29, 30, or 31 days.

Worked examples (1)

Date & Timebeginner

Get the last day of a month with EOMONTH

=EOMONTH(A2,0)

Open formula EOMONTH reference

Common errors with EOMONTH

Result displays as a number

EOMONTH returns a date serial number. Format the result cell as a Date to display it correctly.

Off by one month

EOMONTH(A2,0) returns the last day of the month containing A2, not the last day of the next month. Use 1 to get the last day of the following month.

Frequently asked questions

How do I get the first day of the next month?

Add 1 to EOMONTH — =EOMONTH(A2,0)+1 gives you the first day of the month following the date in A2.

Need a custom variation?

Describe your specific EOMONTH problem and get a formula written for your exact data.

Open generator with EOMONTH