End of the current month
| A | |
|---|---|
| 1 | Date |
| 2 | 3/9/2024 |
Formula: C1: =EOMONTH(A2,0)
Result: 3/31/2024
0 months means the month of the start date.
Google Sheets function
EOMONTH in Google Sheets
EOMONTH with worked examples you can test in the live grid. The argument details are in the Excel guide.
In Google Sheets
The arguments and common errors are covered in the EOMONTH Excel guide; check the function help in Google Sheets for its own argument list.
Worked examples in Google Sheets
End of next month
| A | |
|---|---|
| 1 | Date |
| 2 | 3/9/2024 |
Formula: C1: =EOMONTH(A2,1)
Result: 4/30/2024
Positive months move forward; negative move back.
Days in a month
| A | |
|---|---|
| 1 | Date |
| 2 | 2/10/2024 |
Formula: C1: =DAY(EOMONTH(A2,0))
Result: 29
The day number of the last day equals the length of the month. 2024 is a leap year.
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in F2: =EOMONTH(A3,1)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Start | End | Holiday | Time | Result | |
| 2 | 3/15/2026 | 6/20/2026 | 5/1/2026 | 14:45 | 2/28/2026 | |
| 3 | 1/31/2026 | 2/28/2026 | 5/9/2026 | 09:30 | ||
| 4 | 12/24/2025 | 1/9/2026 |
Result in F2: 2/28/2026
Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.