Skip to content

Last day of the month

Find the month-end date for any date, useful for billing and reports.

The formula

Argument separator
Excel and Google Sheets
=EOMONTH(A2, 0)

How it works

  1. A2

    Any date in the month.

  2. 0

    This month. Use 1 for next month's end or -1 for last month's end.

Example

A: DateB: Result
2026-02-102026-02-28
2026-07-012026-07-31

Tips

  • First day of the month: =EOMONTH(A2, -1)+1.