FormulaCraft

EOMONTH

EOMONTH returns the last day of the month a given number of months before or after a date. Use 0 for the current month-end, 1 for next month, -1 for last.

Excel
=EOMONTH(A2, 0)
Google Sheets
=EOMONTH(A2, 0)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 is the starting date.
  2. 20 returns the end of that same month.
  3. 3Use a positive or negative number to shift forward or back.

Need a version for your data?

Try: “Get the last day of the month for the date in A2”

Related

TODAY / DATEDIFNETWORKDAYSWEEKDAY

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: