SheetsdrillEOMONTH and EDATE
EOMONTH(start_date, months) returns the last day of the month that is a given number of months after the start date, and EDATE(start_date, months) returns the same day of the month that many months away. Use 0 for the current month, 1 for next month and -1 for last month.
Syntax
=EOMONTH(start_date, months) and =EDATE(start_date, months)| Part | What it is |
|---|---|
start_date | The reference date, usually a cell or TODAY(). |
months | How many months to move: positive forward, negative back, 0 for the same month. |
Examples
=EOMONTH(DATE(2026,11,3), 1)Result: 12/31/2026 (due at the end of next month)
=EOMONTH(A2, 0)Result: The last day of the month of the invoice date in A2
=EOMONTH(A2, -1)+1Result: The first day of the month of A2
Last day of the previous month plus one.
Common mistakes
- The result shows a number like 46387; format the cell as a date.
- Using EOMONTH(A2, 1) for the first of next month returns the last day of next month; use EOMONTH(A2, 0)+1.
- Adding 30 days instead of EDATE gives drifting dates across months; EDATE keeps the day of month.
Practice EOMONTH and EDATE
These drills check your answer on live data, free, no account needed.
- Due at the end of next monthInvoices are due on the last day of the month after the invoice date. Fill B2 and B3 using EOMONTH.
Questions
How do I get the first day of the current month?
=EOMONTH(TODAY(), -1)+1, or =DATE(YEAR(TODAY()), MONTH(TODAY()), 1).
How do I add 12 months to a date?
=EDATE(A2, 12) returns the same day next year, with February 29 becoming February 28 in a non-leap year.
Related
- DATE, YEAR, MONTH and DAYHow DATE, YEAR, MONTH and DAY work in Google Sheets to build a date from parts, pull the year or month out of a date, group by month and fix text dates.
- TODAY and NOWHow TODAY and NOW in Google Sheets return the current date and time, how to calculate days until a deadline, age and overdue flags, and why the value changes.
- NETWORKDAYSHow NETWORKDAYS and NETWORKDAYS.INTL in Google Sheets count working days between two dates, exclude holidays, use custom weekends, and add days with WORKDAY.
- DATEDIFHow DATEDIF in Google Sheets returns whole years, months or days between two dates, with the unit codes, examples for age and tenure, and common errors.