To add days to a date in Excel, add the number of days to the date cell: with a starting date in A2 and the number of days in B2, enter =A2+B2 in C2. Excel returns the resulting date when C2 is formatted as a date; for example, November 2, 2026 plus 10 days is November 12, 2026.
The Basic Date-Plus-Days Formula
Excel stores dates as serial numbers, so ordinary addition works: a date is a number, and one calendar day advances that number by one. You do not need a special function to add a fixed number of days. If A2 contains November 2, 2026 and B2 contains 10, the formula =A2+B2 returns the serial value for November 12, 2026. The displayed result depends on the number format applied to the formula cell.
For a quick calculation with the starting date directly in the formula cell A2, enter =A2+7 in B2. This adds exactly seven calendar days. It does not skip Saturdays, Sundays, or holidays. If you want to add a different number, replace 7 with that number or, more flexibly, refer to a cell containing the number of days.
Use a real Excel date in A2, not text that merely looks like a date. You can enter a date in a format Excel recognizes for your regional settings, or create it with Excel’s date-entry controls. If Excel recognizes the entry, it will usually align it to the right by default, but alignment is not a conclusive test because cell formatting can change how values appear.
Set Up a Reusable Calculation
A simple worksheet layout makes the calculation easy to update and copy down. Put starting dates in column A, day counts in column B, and the formula result in column C. With the starting date in A2, the day count in B2, and the result intended for C2, enter =A2+B2. Change either input and the result updates automatically.
To calculate several rows, put a different date and day count in each row, then copy the formula from C2 downward. Excel adjusts the relative references for each row: the next result refers to A3 and B3, the following one to A4 and B4, and so on. In Microsoft 365 for Windows, select C2 and drag the small square at the lower-right corner of the selection, called the fill handle, down the column. Double-clicking the fill handle can fill the formula alongside a neighboring continuous data column.
If every row should add the same number of days, store that number in one cell instead of typing it into each formula. For example, put 14 in E1. With the starting date in A2, the shared day count in E1, and the result in B2, enter =A2+$E$1. The dollar signs make E1 an absolute reference, so it stays fixed when the formula is filled down. Without them, Excel would shift the reference to E2, E3, and so forth.
Format the Result as a Date
A correct calculation may appear as a number such as 46338 rather than a familiar date. That is usually a display-format issue, not a failed formula: the result is a date serial, but the cell is currently set to show a general number. Select the result cell or range, then use Home > Number Format drop-down > Short Date. Choose Long Date if you want a display that spells out the weekday and month.
For more control, open Format Cells and choose a date format. On Windows, Ctrl+1 opens Format Cells; on Mac, Command+1 is the corresponding shortcut. Formatting changes how a value is displayed, not the underlying date arithmetic. A custom format can show a date as day-month-year, month-day-year, or another supported pattern while keeping the same date value for calculations.
If the formula result shows #######, the value is often valid but the column is too narrow to display the chosen format. Widen the column or select a shorter date format. If the result displays a date but appears one day off, check the starting value, the day count, and whether you intended to include the start date. The basic addition formula counts forward from the starting date; adding 1 to November 2 gives November 3.
Calendar Days Versus Business Days
The plus-sign method counts every calendar day, including weekends and holidays. Use it for deadlines, travel dates, delivery estimates expressed in calendar days, or any instruction that literally says to add a number of days. If a period begins Monday and lasts five calendar days under this calculation, adding 5 lands on Saturday.
For a workday calculation that excludes Saturday and Sunday, use Excel’s WORKDAY function. With a starting date in A2, the number of workdays to add in B2, and the result in C2, enter =WORKDAY(A2,B2). WORKDAY does not count the starting date as the first added workday: if A2 is Monday, November 2, 2026, adding 5 workdays returns Monday, November 9, 2026.
You can also provide a range of holiday dates for WORKDAY to skip. If the starting date is in A2, the number of workdays is in B2, holiday dates are in F2:F10, and the result is in C2, enter =WORKDAY(A2,B2,$F$2:$F$10). The holiday cells must contain actual Excel dates, not text labels. Holidays that fall on a weekend do not cause an extra skipped weekday, because the weekend is already excluded.
WORKDAY is available in current Excel versions, including Microsoft 365. If your workweek does not run Monday through Friday, use WORKDAY.INTL. For example, with the same start date, day count, and holiday range, enter =WORKDAY.INTL(A2,B2,1,$F$2:$F$10) in C2. The weekend argument 1 specifies Saturday and Sunday as weekend days; other supported weekend patterns let you define different nonworking days.
Adding Days From Today or Moving Backward
To calculate a date a set number of days from today, Excel’s TODAY function supplies the current date and updates it when the worksheet recalculates. In a worksheet where B2 is the intended result cell and no input cell is needed, enter =TODAY()+30 to show the date 30 calendar days from today. Because TODAY is dynamic, the result changes as the current date changes; it is not a permanent timestamp.
To preserve a fixed result, copy the formula cell and use Paste Special > Values, or enter a date as a value. This is useful when recording the date a task was due or when a report must retain the calculation date rather than recalculate later. Confirm the pasted value is displayed as a date, since Paste Values keeps the calculated value but does not necessarily apply the date format you want.
Adding a negative number moves backward. With a date in A2, a negative day count such as -3 in B2, and the result in C2, use =A2+B2. If A2 is November 2, 2026, the result is October 30, 2026. The same formula therefore handles both future and past dates; no separate subtraction function is required.
Adding Days Is Not the Same as Adding Months
A month does not have a fixed number of days. Adding 30 days may land in the next month or the month after that, depending on the starting date. If you mean “one month later,” use a month-based calculation rather than adding 30. For a starting date in A2 and the result in B2, enter =EDATE(A2,1) to move forward one month. EDATE returns the corresponding day in the target month when possible; if that day does not exist, it returns the final day of the target month. For example, one month after January 31 is the last day of February.
This distinction matters for billing cycles, anniversaries, and monthly schedules. “30 days after the date” means a fixed 30-day interval, while “the same date next month” is a calendar-month instruction and can behave differently around short months. Decide which meaning the task requires before choosing a formula.
Common Errors and Date-Entry Problems
- The result is an ordinary number: Apply a date number format to the result cell. Excel’s date arithmetic can be correct even when the display is not what you expect.
- The formula returns an error or does not change: Check that the starting date and day count are numeric values. A date-looking text string may not be usable as a date, and a number stored as text may not behave as expected.
- The result is one day later or earlier than intended: Clarify whether the starting date counts as day one. Adding 1 to a date returns the following day; it does not return the starting date.
- The date is interpreted with the wrong month and day: Excel interprets typed dates according to regional settings. Enter dates unambiguously for your locale, or build them from numeric year, month, and day inputs with Excel’s DATE function.
- A date changes after copying between workbooks: Excel workbooks can use different date systems. Copying raw date serials between workbooks that use different systems can shift the displayed date; check the workbook’s date-system setting and compare actual dates rather than assuming serial values are interchangeable.
If you need to check whether an input is numeric before adding, an optional formula can display a message instead of attempting the calculation. With a date in A2, a day count in B2, and the check in C2, enter =IF(ISNUMBER(A2),A2+B2,"Check date"). This tests the starting-date cell; it does not validate every possible date-entry problem or guarantee that B2 contains a suitable day count, so check both inputs when diagnosing a workbook.
Frequently Asked Questions
What is the simplest Excel formula to add days to a date?
Add the number of days to the date cell, such as =A2+10 when A2 contains the starting date and you want a result 10 calendar days later. Format the result as a date if Excel displays a serial number.
How do I add 30 days to today in Excel?
Enter =TODAY()+30 in the cell where you want the result. TODAY updates with the current date when Excel recalculates, so the result moves over time unless you replace the formula with its value.
How do I add days but skip weekends?
Use WORKDAY rather than ordinary addition. For a starting date in A2 and a number of workdays in B2, =WORKDAY(A2,B2) skips Saturday and Sunday. Add an optional holiday-date range when those dates must also be excluded.
Why does Excel show a number after I add days?
Excel stores dates as serial numbers. Select the result and choose a date format from Home > Number Format drop-down > Short Date; the number should then appear as a calendar date.
Can I subtract days using the same formula?
Yes. Enter a negative day count or subtract directly. With the date in A2 and the result in B2, =A2-5 returns the date five calendar days earlier than A2.
Related
- Data Validation Greyed Out in Excel? Causes and Fixes
- Excel Data Validation Guidelines for Reliable Spreadsheets
- Excel Data Validation From Another Workbook: Best Methods
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- LEFT and LEN Excel Formula: How to Use Them TogetherTo remove the last character from text in Excel, combine LEFT and LEN like this: =LEFT(A2,LEN(A2)-1). With the…
- Excel LAMBDA Use Cases: Practical Examples and LimitsExcel’s LAMBDA function lets you turn a calculation into a reusable custom function, so you can give a…
- Excel Formula for Variance Between Two CellsTo calculate the difference between two cells in Excel, subtract one from the other: with the earlier or…
- Excel EDATE With Days Instead of Months: What to UseNo. EDATE adds months, not days; if A2 contains 10-Feb-2024 and B2 contains 30, use =A2+B2 to get…
- Excel Formula for Every Friday Date in a Date Range ListWith a start date in A2 and an end date in B2, this Microsoft 365 formula returns every…
- HLOOKUP Examples for Beginners in ExcelHLOOKUP searches across the top row of a table and returns a value from a specified row beneath…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.