If A2 contains a real Excel date, add a number of days in B2 with =A2+B2; for a fixed number, use =A2+10. Excel returns a new date, which you can format to display as a calendar date rather than a number.
The basic date-plus-days formula
Excel treats dates as numbers, so adding days is ordinary addition. If A2 contains January 15, 2026, and B2 contains 14, enter the first formula below in C2; the result is January 29, 2026. If you always want to add ten days to the date in A2, use the second formula instead; it returns January 25, 2026.
For the first example, A2 contains January 15, 2026, and B2 contains 14: =A2+B2.
For the second example, A2 contains January 15, 2026, and the number of days is fixed at 10: =A2+10.
Enter the formula in a different cell from the starting date, such as C2, so the original value stays available. If you type a date directly into a formula, Excel also accepts a date made with the DATE function, but a cell reference is usually easier to update and audit.
Why adding a number works
Excel stores a date as a serial number: whole-number steps represent days, and the cell’s number format makes that value look like a date. Adding 1 advances the serial by one day; adding 30 advances it by 30 days. The calendar display accounts for month lengths and leap years, so you do not need to calculate how many days are in each month.
This also explains why a result may initially look like an unexpected number. The calculation can be correct while the result cell is formatted as General or Number. For example, a value such as 46037 is a date serial, not an error or a count of days. Applying a date format changes how the value is shown, not the underlying date calculation.
Excel workbooks can use different date systems, and moving dates between workbooks with different systems can shift displayed dates. For ordinary work inside one workbook, you generally do not need to change the setting; just be cautious when copying date values between files if the dates suddenly differ by several years.
Add days using cell references
Referencing a days cell makes a schedule easier to maintain than hard-coding a number into every formula. Put a start date in A2, a number of days in B2, and enter the formula in C2. With January 15, 2026, in A2 and 14 in B2, C2 displays January 29, 2026. Change B2 to 30 and the result updates to February 14, 2026.
When applying the calculation to multiple rows, enter the formula in the first result row and fill it down. With each row’s starting date in column A and its day count in column B, the formula in C2 adjusts to use A3 and B3 when copied to C3, then A4 and B4 in C4. These are relative references, which is usually what you want for a row-by-row list.
If many rows share one common delay value stored in F1, lock that reference so it does not move when you fill the formula down. With each row’s date in column A, the shared number of days in F1, and the result in column C, enter this in C2: =A2+$F$1. If A2 is January 15, 2026, and F1 is 10, the result is January 25, 2026. The dollar signs keep the reference fixed on F1 while A2 changes by row.
Subtract days and count date ranges
A negative day count moves backward. With A2 containing January 15, 2026, enter this in B2 to get January 8, 2026: =A2-7. The same result comes from adding negative seven. This can be useful for calculating a reminder date, a preparation deadline, or a date before an event.
Adding days and counting days in a period are related but not identical tasks. If A2 is January 1, 2026, and B2 is January 7, 2026, subtracting the start from the end gives 6 elapsed days. If you mean to count both January 1 and January 7 as included calendar dates, the inclusive total is 7. With the start date in A2 and the end date in B2, calculate that inclusive count in C2 with =B2-A2+1.
That extra 1 is a frequent source of confusion in schedules and date ranges. “Seven days after January 1” is January 8, while “January 1 through January 7, inclusive” covers seven calendar dates. Decide whether you are calculating elapsed time or counting both endpoints before choosing the formula.
Calendar days versus working days
Simple addition counts every calendar day, including Saturdays, Sundays, and holidays. That is right for many tasks, such as adding a trial period or finding a date 30 days after an event. It is not the same as adding a number of business days. For a weekday-based deadline, use Excel’s WORKDAY function, which skips weekends and can also skip listed holidays.
For example, put January 15, 2026, in A2, and put January 19, 2026, in E2 as a holiday; the remaining cells in E2:E10 can contain other holidays. Enter this formula in B2 to find the date five working days after A2: =WORKDAY(A2,5,$E$2:$E$10). The result is January 23, 2026: Friday the 16th is day one, Monday the 19th is excluded as a holiday, and Friday the 23rd is day five.
WORKDAY treats Saturday and Sunday as the weekend by default. If a workplace has different weekend days, Excel also has WORKDAY.INTL, which lets you specify the weekend pattern. Check the function’s arguments for the weekend arrangement you need, and keep holiday entries as actual Excel dates. A date typed as text may not be recognized as a holiday.
Adding days is not the same as adding months
Adding 30 days does not mean adding one calendar month. Months have different lengths, so a date-plus-days formula follows the calendar day count instead. For instance, January 31, 2026, plus 30 days is March 2, 2026, not February 28. If your intent is to move by calendar months, use EDATE instead.
With January 31, 2026, in A2, this formula in B2 returns February 28, 2026: =EDATE(A2,1). EDATE moves by a specified number of months and adjusts to the last valid day when the target month does not contain the starting day number. Use a date-plus-days formula for a duration measured in days; use EDATE when the requirement is expressed as months.
Similarly, adding 365 days is not always the same as moving forward one calendar year, because a leap year can add an extra day. If a contract, billing cycle, or policy specifies a year or month rather than an exact number of days, clarify how that period is defined before choosing a calculation.
Format the answer as a date
If the formula result appears as a large number, select the result cell and apply a date format. On Windows, press Ctrl+1 to open Format Cells, choose a date format, and select OK. On Mac, Command+1 opens Format Cells. You can also use the date-format controls on the Home tab. The underlying value remains a number; formatting only changes its display.
If you see a row of number signs such as #### instead, the column may simply be too narrow to show the formatted date. Widen the column or choose a shorter date format. If the result shows a time as well as a date, the cell may have a date-and-time format; select a date-only format if you do not want the time displayed.
Common problems and how to fix them
- The result is a serial number: Apply a date format to the formula cell. The arithmetic may already be correct.
- The formula returns an error or does not update: Confirm that the starting date and day count are numeric values, and that the formula begins with an equals sign. A date that looks normal can still be text if it was imported or entered in an unrecognized format.
- The result is one day off: Check whether the task means elapsed days, an inclusive date range, calendar days, or working days. These count differently.
- The date changes unexpectedly when copied down: Check whether references should move with each row or stay fixed. Use dollar signs around a shared cell reference, as in
$F$1, when it must remain unchanged. - A date appears as text: Re-enter it in a format Excel recognizes for your regional settings, or convert the imported text to a real date before calculating. Changing the cell’s display format alone does not convert text into a date value.
Another useful check is to temporarily format the starting date and result as dates and inspect the day count cell as a number. This can reveal that the input is blank, contains text, or has an unintended decimal. A decimal day count represents a fraction of a day, so 1.5 adds one and a half days, not just one full calendar day.
Dates that include times
Excel can store a time as a decimal fraction attached to a date. For example, a value may represent January 15 at noon rather than midnight. Adding one day preserves the time of day because it adds one whole day to the full date-and-time value. Thus a timestamp at noon remains at noon on the following date.
If you only want to display the calendar date, apply a date-only format; the time can still remain in the cell’s value. If you need to remove the time for a separate calculation, make a copy or use an appropriate date-only calculation, taking care not to discard time information that another part of the workbook needs.
Frequently Asked Questions
What is the simplest Excel formula to add days to a date?
Use the starting date plus a number, such as =A2+7, when A2 contains the date. It returns the date seven calendar days later. Use a cell reference for the day count, such as =A2+B2, if that number may change.
How do I add only business days in Excel?
Use WORKDAY rather than ordinary addition. It skips Saturday and Sunday by default, and you can provide a range of holiday dates as the optional third argument. For weekends that differ from Saturday and Sunday, use WORKDAY.INTL.
Why does Excel show a number instead of a date?
The result cell is likely formatted as General or Number. Select a date format; the number is Excel’s stored date value. If changing the format does not help, check whether the original input is text rather than a real date.
How do I add one month instead of a set number of days?
Use EDATE with a date and a month count. Adding 30 days is not equivalent to adding one month, because calendar months have different lengths and the result can land in a different month.
Can I use a negative number of days?
Yes. Adding a negative number, or subtracting a positive number, moves the date backward. For example, subtracting 7 from January 15 gives January 8.
Related
- Markdown Table Merge Cells? What You Can Do
- PHP Backend Data Validation: A Practical Guide
- Protect Sheet in Excel: Allow Editing in Certain Cells
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Row Index: Find and Use Worksheet Row NumbersAn Excel row index is a row’s position: on a worksheet, it is the number shown at the…
- Excel Formula for Current Time: NOW, TIME, and UpdatesTo show the current date and time in Excel, enter =NOW(). To show only the time, use the…
- Excel Named Range in a Formula: How to Use It CorrectlyIn Excel, use a named range in a formula by typing its name where you would normally put…
- Excel Time Math: Formulas for Adding and Subtracting HoursExcel time math treats times as fractions of a 24-hour day: subtract an earlier time from a later…
- Excel Time Formulas: Calculate Overnight PM-to-AM HoursIf A2 contains a PM start time and B2 contains the following AM finish time, enter =MOD(B2-A2,1) to…
- Remove Spaces in Excel: The Shortcut and Right MethodTo remove every ordinary space from selected cells in Excel for Microsoft 365 on Windows, select the cells,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.