To add one calendar month to a date in Excel, use the EDATE function: if the starting date is in A2, enter =EDATE(A2,1). EDATE returns the date one month later and adjusts to the last valid day when the destination month is shorter, so January 31 can become February 28 or 29.
What EDATE does
EDATE moves a date by a number of calendar months. Its first argument is the starting date, and its second is the number of months to move: a positive number moves forward and a negative number moves backward. The function calculates a date, not a fixed number of days. As a result, adding one month might advance 28, 29, 30, or 31 days, depending on the dates involved.
With the starting date in A2, =EDATE(A2,1) returns the date one month after A2. For instance, if A2 contains June 12, 2025, the result is July 12, 2025. If A2 contains June 12, 2025 and the second argument is -1, =EDATE(A2,-1) returns May 12, 2025. A value such as 3 moves three months forward.
Excel stores dates as numbers and displays them using a date format. EDATE returns a date serial value, so the result may appear as a number if the result cell is formatted as General or Number. That does not necessarily mean the calculation failed; applying a date format usually makes the result readable.
Enter the formula and fill it down
Put valid Excel dates in a column, then use EDATE in the adjacent column. For a simple one-off calculation, type the formula in a blank cell and replace A2 with the cell that contains your date. For a list, place the formula beside the first date and copy it down to calculate each row.
- Enter a date in A2, such as 6/12/2025. Make sure Excel recognizes it as a date rather than text.
- Select B2 and type
=EDATE(A2,1), then press Enter. - Check that B2 displays the expected month and day. If the result is a serial number, format B2 as a date.
- To apply the calculation to more rows, select B2 and drag its fill handle down, or copy and paste the formula into the cells below.
When copied down, the relative reference changes automatically: the formula in B3 refers to A3, and the formula in B4 refers to A4. If every row should use a single fixed start date, use an absolute reference instead. With the fixed start date in A2 and a month count in B2, enter =EDATE($A$2,B2) in C2. The dollar signs keep the start-date reference fixed when you copy the formula down, while B2 changes to B3, B4, and so on.
In Excel for Microsoft 365 on Windows, enter the formula in the formula bar or directly in the cell. The formula syntax is the same in Excel for Mac and Excel for the web. If your Excel installation uses semicolons instead of commas as formula separators because of regional settings, follow the separator Excel accepts in your workbook.
What happens at the end of a month
Months do not all have the same number of days, so a date such as the 31st cannot always be carried into the next month unchanged. EDATE handles this by returning the last date available in the target month. That adjustment is a normal part of the function, not an error.
- With January 31, 2025 in A2,
=EDATE(A2,1)returns February 28, 2025. - With January 31, 2024 in A2,
=EDATE(A2,1)returns February 29, 2024, because 2024 is a leap year. - With March 31, 2025 in A2,
=EDATE(A2,1)returns April 30, 2025. - With January 30, 2025 in A2,
=EDATE(A2,1)returns February 28, 2025, because February has no 30th.
For dates that exist in both months, EDATE keeps the day number: June 30 plus one month becomes July 30. The result is not always the final day of the next month. For example, February 28 plus one month is March 28, not March 31. This distinction matters when a schedule is meant to happen on the same numbered day each month versus at each month’s end.
EDATE or EOMONTH: choose the intended result
Use EDATE when you want to move by calendar months while preserving the day number where possible. Use EOMONTH when you specifically need the last day of a month. These functions solve related but different problems, and choosing the right one avoids subtle schedule errors.
With the starting date in A2, =EOMONTH(A2,1) returns the final day of the month after A2. If A2 is June 12, 2025, the result is July 31, 2025. By contrast, =EDATE(A2,1) returns July 12, 2025. If A2 is already January 31, both functions return February 28, 2025 for a one-month move, but that matching result does not make the functions interchangeable for other starting days.
EOMONTH is useful for month-end reporting, closing dates, and calculations that explicitly depend on the last calendar day. EDATE is often better for anniversaries or recurring dates such as the 12th of each month. For an end-of-month series, calculate each row from the original start date with EOMONTH and a month count, rather than repeatedly using EDATE if the desired rule is always month-end.
Why adding 30 days is not the same
A common shortcut is to add 30 to a date, but Excel interprets that as 30 days, not one month. Since calendar months vary in length, the result can land on a different day than a calendar-month calculation. With June 12, 2025 in A2, adding 30 days produces July 12, 2025 by coincidence; for other dates, the result can differ. For example, adding 30 days to January 31, 2025 reaches March 2, while EDATE returns February 28.
Similarly, the formula =A2+1 adds one day, not one month. Date arithmetic is useful when the requirement is truly a number of days, such as a deadline exactly 14 days after a start date. For a calendar-month rule, use EDATE; for the final day of a target month, use EOMONTH. State the rule in terms of calendar months or days before building a schedule, especially when dates determine reminders, billing periods, or project milestones.
Format the result as a date
If the formula returns a number such as 45850, Excel may be showing the underlying date serial instead of a formatted date. Select the result cells, then choose Home > Number Format and select Short Date or Long Date. You can also open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, choose the Number tab, and select Date or a suitable custom format.
Formatting changes how the value appears; it does not change the date calculation. A custom format can show a compact result such as 12-Jul-2025 or include the weekday, while the underlying cell remains a date that can be sorted and used in calculations. Avoid converting a date to text just to change its appearance if you still need to calculate with it.
If the result remains unchanged after applying a date format, check whether the input is a real date. A date imported from a text file or copied from a webpage may look like a date but be stored as text. Excel’s interpretation of text dates can depend on regional settings, so a string such as 03/04/2025 can mean March 4 or April 3 in different date conventions. Confirm the intended day and month before using it in a schedule.
Common problems and practical checks
When a result seems wrong, first check the source value and the rule you actually need. A formula can be syntactically correct but still produce an unexpected result if the date is text, the input cell contains a time, or the intended rule was month-end rather than the same day of the month.
- The cell shows a number: apply a date format. Excel stores dates as serial values, and General format can expose that number.
- The formula shows as text: check that the cell is not formatted as Text and that the entry begins with an equals sign. Change the format to General, then re-enter the formula.
- The formula returns an error: check that the start value is a valid Excel date and that the month argument is numeric. A text string Excel cannot interpret as a date will not behave like a date value.
- The result is earlier or later than expected: verify that the second argument is the number of months intended. A negative number moves backward; 0 returns the starting month’s corresponding date.
- A time disappears from view: EDATE is designed to return a date, and a standard date format does not display a time. If the time component matters, handle it separately and verify the required behavior.
Excel workbooks can also use different date systems, particularly when files move between platforms or older workbooks. In ordinary Microsoft 365 workbooks, date calculations are usually straightforward, but imported data or a workbook created with a different date system can make serial numbers appear offset. If dates shift substantially after transferring a workbook, check its date-system setting under File > Options > Advanced in Excel for Windows, in the When calculating this workbook section. Do not change that setting casually in a shared file, because it can affect existing date values.
Use EDATE for recurring schedules
EDATE is useful for monthly reminders, subscription dates, review intervals, and other schedules defined by calendar months. If a start date is in A2 and a month interval is in B2, calculate each due date from the original date and the relevant month count. This is generally clearer than building a chain in which each new date depends on the previous result.
For example, suppose A2 contains January 31, 2025 and B2 contains 1. With the start date in A2 and the month count in B2, =EDATE($A$2,B2) returns February 28, 2025. If the next row’s month count is 2, the same pattern returns March 31, 2025, because it calculates two months after the original January 31 date. By contrast, repeatedly adding one month to the prior result can carry a shortened February date forward and produce March 28. Which pattern is right depends on the intended schedule: anchor each date to the original day, or continue from the immediately preceding date.
This difference is worth deciding before creating a long series. For a monthly payment date intended to remain on the 31st when possible, calculating from the original anchor preserves that intent after short months. For a process whose next date is explicitly one month after the last completed date, a chained calculation may reflect the business rule more closely. Excel provides the calculation; it cannot decide which schedule rule your organization means.
Frequently Asked Questions
What formula adds one month to a date in Excel?
Use =EDATE(A2,1) when A2 contains a valid date. Replace A2 with the cell holding your starting date. EDATE moves one calendar month forward and adjusts to the last valid day if the target month is shorter.
How do I subtract one month from a date?
Use a negative month count. If the date is in A2, =EDATE(A2,-1) returns the date one calendar month earlier, with the same month-end adjustment rule.
How do I add one month but always get the last day of that month?
Use EOMONTH instead. With a starting date in A2, =EOMONTH(A2,1) returns the last calendar day of the following month, whether A2 falls near the beginning or end of its month.
Why does January 31 plus one month return February 28?
February does not have a 31st, so EDATE returns the final valid day in February. In a leap year that final day is February 29; otherwise it is February 28.
Can I add a month with a regular plus sign?
A plus sign adds a numeric number of days to an Excel date, not a calendar month. Use EDATE for calendar-month movement, or EOMONTH when you need the target month’s last day.
Related
- Data Validation Multiple Selection in Excel: What Works
- Data Validation Interview Questions and Strong Answers
- Data Validation Greyed Out in Excel? Causes and Fixes
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel IFS in Conditional Formatting: How to Use ItYes. In Excel for Microsoft 365 on Windows, you can use the IFS function in a conditional-formatting formula,…
- HLOOKUP in Excel With Multiple Sheets: A Practical GuideHLOOKUP does not search multiple worksheets in a single lookup operation. To search several sheets, combine separate HLOOKUP…
- COUNTIF Excel Blank? Count Empty Cells CorrectlyTo count blank cells in Excel, use =COUNTIF(A2:A20,""), replacing A2:A20 with your range. COUNTIF can also count cells…
- Excel MID Function: Extract Text from a Cell’s MiddleTo extract characters from the middle of a cell in Excel, use the MID function, which takes a…
- IFERROR Excel SUM: How to Ignore Errors in a TotalTo add a range while treating error cells as zero, use =SUM(IFERROR(A2:A10,0)), assuming the values and any errors…
- Excel Data Validation INDIRECT Formula: Dependent ListsIn Excel for Microsoft 365 on Windows, use =INDIRECT($A2) as the Data Validation list source in B2 when…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.