Quick Navigation
EDATE Function
Summary
The Excel EDATE function returns a date that is a specified number of months before or after a start date. Perfect for calculating maturity dates, due dates, or any date that needs to maintain the same day of the month.
Syntax
EDATE(start_date, months)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| start_date | Date |
Yes | Start date for the calculation. Enter as DATE(YYYY,MM,DD) or cell reference. |
| months | Number |
Yes | Months to add (positive for future dates) or subtract (negative for past dates). |
Using the EDATE Function
EDATE is essential for date arithmetic that works by months rather than days. Use it to project future payment dates, contract expirations, or subscription renewals while preserving the day of the month.
Common EDATE Examples
One Month Forward
=EDATE("1/15/2024", 1)Returns February 15, 2024 - perfect for monthly billing cycles.
Three Months Backward
=EDATE(DATE(2024,6,20), -3)Returns March 20, 2024 from June 20 start date.
Project End Date
=EDATE(A2, B2)Calculates project completion date when A2 is start date and B2 contains duration in months.
Frequently Asked Questions
Common Errors and Solutions
#VALUE!
Cause: start_date is invalid or text
Solution: Use DATE(YYYY,MM,DD) function or ensure cell contains proper date
#NUM!
Cause: Date calculation results in invalid date
Solution: Check your month values and start date
Wrong day of month
Cause: Manual date entry as text
Solution: Always use DATE function for reliable results
Notes
- Excel stores dates as serial numbers starting from 1/1/1900
- Positive months = future dates, negative = past dates
- Use with TODAY() for dynamic calculations
- Perfect companion for EOMONTH function
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+