To add three calendar months to a date in Excel, use =EDATE(A2,3), assuming the starting date is in cell A2. EDATE returns the date three months later and adjusts to the last valid day when the target month is shorter, so January 31 becomes April 30 rather than a date in May.
How the EDATE formula works
EDATE is Excel’s purpose-built function for moving a date by a number of months. Its syntax is EDATE(start_date, months): the first argument is the starting date, and the second is how many months to move. A positive number moves forward; a negative number moves backward. The number can be a cell reference or a calculation, not only a typed constant.
With the starting date in A2, the formula =EDATE(A2,3) adds three months. If A2 contains June 15, 2026, the result is September 15, 2026. The function preserves the day number when that day exists in the destination month. If it does not, Excel uses that month’s final day. This calendar-month behavior is different from adding a fixed number of days.
Excel stores dates as serial numbers and applies a date format to display them as dates. EDATE therefore returns a date value that can be used in other calculations, sorting, or date comparisons, even if the cell initially displays as a number. EDATE is available as a standard function in current Microsoft 365 Excel for Windows; you do not need to install an add-in.
Enter the formula and display the result
For a straightforward calculation, put a valid Excel date in A2, select another cell such as B2, and enter =EDATE(A2,3). Press Enter. The formula stays in B2, and Excel calculates the result from the date in A2. If you change A2 later, B2 updates automatically.
If the result appears as a number such as 46280, the calculation may be correct but the cell is formatted as General or Number. Select the result cell and choose Home > Number > Short Date. For a different display, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, then choose a date format. Formatting changes how the value looks; it does not change the underlying date.
You can also use a date written directly in a formula, but a cell reference is usually easier to maintain. If you do type a date in a formula, use DATE to avoid ambiguity between regional date conventions. With no input cells required, the formula =EDATE(DATE(2026,6,15),3) returns September 15, 2026. Here, DATE constructs June 15, 2026 from year, month, and day arguments before EDATE moves it forward.
What happens at the end of a month
Month-end adjustment is one of the most important details. EDATE does not simply keep counting days until it reaches a month with the same day number. It aims for the corresponding day in the target month, then clamps the result to the final day if that day number is unavailable.
- January 31 plus three months is April 30.
- November 30 plus three months is February 28 in a common year, or February 29 in a leap year.
- May 31 plus three months is August 31, because August has a 31st day.
- August 31 plus six months is February 28 or 29, depending on the year reached.
This rule is useful for many monthly schedules, but the result may not match every organization’s definition of a recurring date. For example, a process that must always occur on the last day of each month needs an explicit end-of-month rule. If that is what you mean, use EOMONTH rather than assuming EDATE will always return a month’s final day.
Use a variable number of months
A month interval can come from a worksheet cell, which makes one formula reusable for different records. With starting dates in A2:A20 and the number of months to add in B2:B20, enter =EDATE(A2,B2) in C2 and fill it down. Each row uses its own date and interval. For example, if A2 is June 15, 2026 and B2 is 3, C2 returns September 15, 2026.
A negative interval moves backward. With a date in A2, =EDATE(A2,-3) returns the date three months before it, subject to the same month-end adjustment. A zero interval returns the starting date. These options can support schedules that calculate both a future review date and a prior-period date.
For a repeated schedule, you can calculate each date from the original start date and its period number rather than adding one month to the previous result. With the original date in A2 and period number 1, 2, 3, and so on in B2:B20, use =EDATE($A$2,B2) in C2 and fill down. The fixed reference keeps the same start date while the period number changes. This is useful when you want each date to follow the original anchor. It also avoids a potential drift in schedules that repeatedly start from an adjusted month-end date.
Three calendar months is not always 90 days
Adding three months means moving to the matching calendar position three months later, where possible. Adding 90 days means counting exactly 90 days. Those calculations can produce different results because months have different lengths. For example, June 15 plus three calendar months is September 15, while adding 90 days to June 15 does not necessarily land on September 15.
If the requirement is specifically a fixed 90-day interval, use addition instead of EDATE. With a date in A2, =A2+90 adds 90 days. Ensure the result cell is formatted as a date. Choose the operation that matches the real rule: billing cycles and monthly reviews often use calendar months, while a policy defined as exactly 90 days calls for day arithmetic. Do not substitute one for the other just because three months is sometimes described informally as a quarter.
EDATE compared with EOMONTH and DATE
EDATE preserves the day of the month when possible. EOMONTH returns the last day of a month a specified number of months away. If A2 contains June 15, 2026, then =EDATE(A2,3) returns September 15, 2026, while =EOMONTH(A2,3) returns September 30, 2026. With a date already at month-end, EDATE may also land on a month-end when the target month is shorter, but it is not a general instruction to use the last day of every target month.
DATE can also construct a date from adjusted year, month, and day numbers. However, DATE normalizes out-of-range days into later months. For example, a formula that asks DATE for February 31 can roll into March, rather than clamping to February’s last day. Therefore, a simple DATE expression is not a drop-in replacement for EDATE when matching a calendar month and adjusting short months are required. Use EDATE for that behavior, and EOMONTH when the desired result is always a month end.
Check dates and troubleshoot unexpected results
EDATE needs a valid date value. A date that looks correct on screen may actually be text copied from another system. If the result is #VALUE!, check that the input is a real Excel date and that the month argument is numeric. Typing a date in a way Excel recognizes for your regional settings usually converts it, but imported text can remain text. DATE(year,month,day) is a reliable way to build an unambiguous date in a formula.
When a result seems one month or several days off, check the intended rule and the input carefully. Common causes include confusing day/month order, using 90 days when calendar months were intended, and overlooking the month-end adjustment. Also verify that the input cell does not contain a time component if the schedule requires dates only; EDATE works with the date portion, but a time value can affect how a result is displayed or compared.
- Confirm the starting cell contains the expected date and year.
- Check whether the month argument is positive, negative, or accidentally text.
- Format the result as a date if it appears as a serial number.
- Compare the output with the required rule: matching day, last day of month, or an exact number of days.
Frequently Asked Questions
What formula adds three months to a date in Excel?
With the starting date in A2, use =EDATE(A2,3). Format the result cell as a date if Excel shows a serial number instead of a calendar date.
Does Excel count three months as 90 days?
No. EDATE advances by three calendar months. The number of days between the starting date and result depends on the months involved. Use =A2+90 only when the requirement is exactly 90 days.
What does EDATE return for January 31 plus three months?
It returns April 30, because April has no 31st day. EDATE uses the last valid day of the target month when the original day number does not exist there.
How do I add months listed in another cell?
With a date in A2 and the number of months in B2, use =EDATE(A2,B2). A positive value moves forward, a negative value moves backward, and zero leaves the date unchanged.
How can I get the last day of the month three months later?
With the starting date in A2, use =EOMONTH(A2,3). EOMONTH is the clearer choice when the requirement is specifically the final calendar day, rather than the same day number three months later.
Related
- Data Validation Testing: Methods and Examples
- Data Validation Studio: Excel Rules, Setup, and Limits
- Power Query Circular Reference: Causes and Fixes
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- How to Get the Filter Option in Excel and Use It EasilyTo get the Filter option in Excel, click a cell in your data and select Data > Filter.…
- Excel LEN Function: Count Characters in Cells EasilyTo count the characters in a cell, put the text in A2, select another cell, and enter =LEN(A2).…
- Remove Spaces in Excel Rows: Trim, Find, and ReplaceTo clean spaces at the start or end of text, or reduce repeated spaces between words, use Excel’s…
- How to Get the Highest Number in Excel with the MAX FunctionTo get the highest number in a range, use Excel’s MAX function. With sample values in A2:A8, enter…
- Excel Color Filter: How to Filter Rows by Cell ColorTo filter rows by color in Excel for Microsoft 365 on Windows, select a cell in your data,…
- Excel IF SUM: How to Combine IF, SUMIF, and SUMIFS FormulasTo test a total and return one result or another, combine IF with SUM: for example, with amounts…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.