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.
Date & time
EOMONTH
Last day of the month.
Syntax
EOMONTH(start_date, months)Example: =EOMONTH(A2,0)
Available in: All versions
EOMONTH returns the last day of the month that is a given number of months before or after a start date: =EOMONTH(start_date, months). Use it for month-end deadlines, billing cycles and counting days in a month.
When to use it
- You need month-end dates for invoices, accruals or reports.
- You want to know how many days a month has.
- You need the first day of next month (EOMONTH plus 1).
- You build date ranges for SUMIFS by month.
Arguments explained
- start_date. The date to start from. A real date or a reference to one is best, because text dates may be misread.
- months. How many months to move. 0 stays in the same month, 1 is next month and -1 is the previous month. The result is always the last day of that month.
- Formatting. The function returns a serial number, so format the cell as a date. For the first day of next month, add 1 to EOMONTH(date,0).
Worked examples
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
Common errors and how to fix them
- Shows a 5-digit number. EOMONTH returns a serial number. Apply a date format if the cell shows 45382.
- #VALUE!. The start date is text that Excel does not recognise as a date.
- #NUM!. The result would fall outside the supported date range.
- Month count is not whole. Decimals in months are truncated. Use integers.
Related functions
Frequently asked questions
- How do I get the first day of the month?
- Use =EOMONTH(A2,-1)+1.
- What is the difference between EOMONTH and EDATE?
- EDATE keeps the same day number; EOMONTH always lands on the last day of the month.
- How do I get the first day of next month?
- =EOMONTH(A2,0)+1.
- Does EOMONTH handle leap years?
- Yes. The February result is 29 in leap years.