If the starting date is in A2 and the number of days to add is in B2, enter =A2+B2 to return a future date. For a date a fixed number of days from today, use =TODAY()+30; use a different number to change the interval.
How Excel calculates future dates
Excel stores dates as serial numbers and displays those numbers in a date format. Adding 1 to a valid date advances it by one calendar day, adding 7 advances it by a week, and adding 30 advances it by 30 days. The formula does not need a special date-addition function for ordinary day intervals.
For example, assume A2 contains June 15, 2026, and B2 contains 30. The formula =A2+B2 returns July 15, 2026. This is a calendar-day calculation: it counts Saturdays, Sundays, and holidays. If the result appears as a number such as 46218 instead of a date, the calculation may still be correct; the result cell simply needs a date number format.
These formulas work in Excel for Microsoft 365 on Windows and also in current Excel for Mac and Excel for the web. The basic date arithmetic is not specific to one version.
Choose a formula for the kind of future date
The right formula depends on what the interval means. Calendar days, calendar months, business days, and a fixed calendar date are different requirements, so choose the calculation that matches the real-world rule.
- Calendar days: Add a number directly, such as 14 days for two weeks.
- Calendar months: Use EDATE, which moves a date by a number of months.
- Working days: Use WORKDAY to skip weekends and optionally listed holidays.
- A particular date: Use DATE to build a date from its year, month, and day components.
Before each formula below, the assumed cell layout is stated so you can adapt it to your worksheet. Enter formulas in a cell that is separate from the input date and interval, unless you intentionally want to replace an input.
Add days to a date or to today
With a starting date in A2 and a number of calendar days in B2, use =A2+B2. If A2 is June 15, 2026 and B2 is 30, the result is July 15, 2026. A negative value subtracts days, so -7 returns one week earlier.
With no starting date in a cell and a need for a date 30 days from the current date, use =TODAY()+30. TODAY returns the current date according to the computer’s date and time settings, and the result updates when Excel recalculates the workbook on a later day. Use this for rolling deadlines, reminders, and reports that should always show a date relative to today.
With a fixed start date that should not move when the workbook is opened later, enter that date in a cell and add the interval, or construct the date with DATE. With the year, month, and day supplied as 2027, 1, and 1, respectively, use =DATE(2027,1,1). DATE avoids ambiguity in how a typed date such as 1/2/2027 might be interpreted under different regional settings.
A common point of confusion is that TODAY does not permanently record the date on which a formula was first entered. It is a live function. If a report needs a date that stays fixed, type the date as a value or use a controlled process to record it; do not rely on TODAY to act like a timestamp.
Add months, quarters, or years
Adding 30 days is not the same as adding one month. Months have different lengths, so use EDATE when the intended interval is measured in calendar months. With a starting date in A2 and a number of months in B2, enter =EDATE(A2,B2). If A2 is January 31, 2026 and B2 is 1, Excel returns February 28, 2026, the last valid day of that month.
With a date in A2 and a three-month interval, enter =EDATE(A2,3). This is useful for a quarterly review date or a payment schedule based on calendar months. For a date in April, adding 3 months gives a date in July while preserving the day number where that day exists.
With a date in A2 and a one-year interval, enter =EDATE(A2,12). EDATE also handles dates near the end of a month and leap-day cases by returning the last valid day when the original day does not exist in the target month. That can be useful for anniversaries, although a business rule may specify a different treatment for a February 29 event.
To find the last day of the next month, with the original date in A2, use =EOMONTH(A2,1). EOMONTH is different from EDATE: it returns the month’s final calendar day, rather than trying to preserve the day number from A2. It is useful for month-end reporting and accounting periods.
EDATE and EOMONTH are available in Microsoft 365 Excel. In some installations, Excel may ask to enable the Analysis ToolPak if one of these functions is unavailable; check the Excel version and add-ins before replacing a valid formula with a more complicated workaround.
Skip weekends and holidays
When a deadline means working days rather than calendar days, WORKDAY skips Saturday and Sunday. With a start date in A2 and a count of 10 working days in B2, enter =WORKDAY(A2,B2). If A2 is Friday, June 12, 2026, the result is Friday, June 26, 2026: the start date is not counted as day one, and weekends are skipped.
WORKDAY can also exclude a holiday list. With the start date in A2, the number of workdays in B2, and holiday dates in F2:F12, use =WORKDAY(A2,B2,$F$2:$F$12). If June 19, 2026 is included in that list, the earlier example shifts from June 26 to June 29, because one otherwise-working day is excluded. The dollar signs keep the holiday range fixed if the formula is copied down a column.
WORKDAY assumes a Saturday-Sunday weekend. For a workweek with different weekend days, use WORKDAY.INTL, which lets you specify a weekend pattern. Check the function’s weekend argument carefully and test it against known dates before applying it to a schedule; organizations can define workdays differently.
Holiday lists must contain real Excel dates, not text that merely looks like dates. Keep the list current, and decide whether company closures, regional holidays, or only statutory holidays should count. Excel cannot infer an organization’s holiday calendar from the formula alone.
Display the result as a readable date
If a calculated result appears as a serial number, select the result cell and choose a date format from Home > Number Format. Short Date is convenient for compact tables; Long Date spells out the weekday and month. The available choices and their appearance can depend on regional settings.
Number formatting changes how a value looks, not the underlying date calculation. For example, a result displayed as 7/15/2026 and the same result displayed as July 15, 2026 can still be used in later date formulas. Avoid converting dates to text just to change their appearance, because text values are harder to sort and calculate with reliably.
When a result looks one day too early or too late, first confirm the starting date, the interval, and whether the rule counts the start date. Adding 10 with ordinary addition includes ten elapsed calendar days after the start; WORKDAY counts forward from the next working day. Those are different counting conventions.
Common problems and how to fix them
- The result is a number: Apply a date number format to the result cell. Excel stores dates numerically, so a number display does not automatically mean the formula failed.
- The formula returns an error or unexpected date: Check that the starting value is a real date and the day or month interval is numeric. A date pasted from a website may be text even when it looks right.
- A date is interpreted in the wrong order: Typing 3/4/2026 can mean March 4 or April 3 depending on regional settings. Use DATE with separate year, month, and day values, or verify the cell’s interpretation.
- A month addition seems to change the day: Shorter months have no matching day number. EDATE returns the last valid date of the target month, such as February 28 when moving one month forward from January 31.
- The answer changes later: TODAY updates as the workbook recalculates. Use a fixed date value if the original date must remain unchanged.
- The result is off by a day for a deadline: Decide whether the starting day counts, whether weekends count, and whether holidays are excluded. Then choose ordinary addition or a workday function accordingly.
Also check for a leading apostrophe or spaces in a date cell, either of which can cause a date-looking entry to be treated as text. Re-entering the date in Excel or using a deliberate conversion method can resolve that issue. Do not assume a displayed date is a valid date value just because it appears in a familiar format.
Build a reusable future-date schedule
A small input table makes schedules easier to maintain than hard-coding different intervals into many formulas. Put start dates in column A, day counts in column B, and the output formula in column C. With the start date in A2 and the day count in B2, enter =A2+B2 in C2, then fill the formula down. Each row will calculate from its own inputs.
For month-based schedules, put a month count in column B and use EDATE instead. If each row represents a different subscription or review, this layout lets a reader change an interval without editing the formula. For working-day schedules, keep a shared holiday list in a separate area and use an absolute reference to that range.
If you need a series of consecutive future dates rather than one result per row, Microsoft 365 can spill a sequence. With a starting date in A2 and a need for the next five consecutive calendar dates, use =A2+SEQUENCE(5). SEQUENCE is available in Microsoft 365 and Excel 2021 or later. The formula returns five dates as a spilled range; format the output cells as dates. It creates calendar dates, not weekdays-only dates.
Frequently Asked Questions
What is the simplest Excel formula for a date 30 days from today?
Use =TODAY()+30. It returns a date 30 calendar days after the current date and changes as TODAY recalculates. Format the result cell as a date if Excel displays a serial number.
How do I add one month to a date in Excel?
With the starting date in A2, use =EDATE(A2,1). It advances by one calendar month and returns the last valid day if the target month does not have the original day number.
How can I calculate a future date excluding weekends?
With a starting date in A2 and the number of working days in B2, use =WORKDAY(A2,B2). Add a holiday range as the third argument if specific dates should also be skipped.
Why does Excel show a number instead of my future date?
Excel represents dates as serial values. Apply a date format through Home > Number Format; the stored value and calculation do not need to change.
Does adding 30 days mean the same as adding one month?
No. Thirty days is a fixed calendar-day interval, while a month can contain 28, 29, 30, or 31 days. Use addition for a specific number of days and EDATE for a calendar-month interval.
Related
- Data Validation Process: Steps, Checks, and Best Practices
- Data Validation Named Range in Excel: Setup and Fixes
- Data Validation Reference Table in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel XLOOKUP Examples for Common Spreadsheet TasksMicrosoft Excel’s XLOOKUP finds a value in one range and returns the corresponding value from another. For example,…
- Excel Sum a Range of Cells: Formulas, Tips, and FixesTo add a range of cells in Excel, use the SUM function: if the numbers are in A1…
- Excel LET Function: How to Name and Reuse CalculationsUse Excel’s LET function to give a name to a value or calculation, then use that name elsewhere…
- COUNTIF in Excel: Count Values Less Than a Set NumberTo count values below a number in Excel, use =COUNTIF(A2:A20,"<10"). Replace A2:A20 with your range and 10 with…
- Excel Date Difference Formulas for Days, Months, and YearsTo find the number of elapsed days between two dates in Excel, subtract the start date from the…
- Combine Cells in Excel That Have Words: Formulas and StepsTo combine words from two Excel cells, enter a formula such as =A2&" "&B2 in an empty cell;…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.