Quick Answer & Formula
Excel
Sheets
Beginner
=EDATE(start_date, months) | =EOMONTH(start_date, months) EDATE returns the same calendar day N months in the future or past: =EDATE(StartDate, 12) adds 1 year. EOMONTH returns the last calendar day of the target month: =EOMONTH(StartDate, 0) gives the last day of the current month.
EDATE & EOMONTH Functions in Excel & Google Sheets
EDATE and EOMONTH are the standard functions for financial modeling, debt maturity schedules, billing cycles, and SaaS subscription renewal dates.
1. Adding Months with EDATE
To find a 1-year (12-month) SaaS renewal date:
=EDATE(A2, 12)To subtract 3 months:
=EDATE(A2, -3)2. Finding Month-End Accounting Close Dates with EOMONTH
To find the final day of the current month:
=EOMONTH(TODAY(), 0)To find the end of Q1/Q2/Q3 quarter (e.g. 3 months from now):
=EOMONTH(A2, 3)
?
Frequently Asked Questions
How do I find the first day of the next month?
Use =EOMONTH(TODAY(), 0) + 1.