Excel Date Plus 1 Day: Formula, Examples, and Fixes

To add one day to an Excel date, add 1 to the date cell. If the date is in A2, enter =A2+1 in another cell; for example, a starting date of April 15, 2026 returns April 16, 2026. If the result shows a number instead of a date, the calculation may be correct—the result cell probably needs date formatting.

Why adding 1 advances a date

Excel stores ordinary dates as serial numbers: each whole-number step represents one day. A date-plus-one calculation therefore adds one to the stored value, moving the date forward by a calendar day. Excel handles month ends and leap years as part of that date sequence, so adding 1 to April 30 produces May 1, and adding 1 to February 28 in a leap year produces February 29.

The date you see in a cell is a display of that underlying value, not a separate kind of data. Excel’s standard 1900 date system is used by most current Windows workbooks. Some older workbooks, particularly those created for early Mac versions of Excel, can use the 1904 date system instead. When workbooks with different date systems are exchanged, dates can appear about four years apart; this is a workbook compatibility issue, not a reason to change the simple plus-one calculation.

The basic formula and a worked example

With a real Excel date in A2, put the formula in B2. For a specific example, if A2 contains April 15, 2026, enter =A2+1 in B2; the result is April 16, 2026. The formula refers to A2, so if you later change the starting date, the result updates automatically.

You can also add a number of days by replacing 1 with the number you need. With the starting date in A2, enter =A2+7 in B2 to return the date one week later. A negative number moves backward: with April 15, 2026 in A2, =A2-1 in B2 returns April 14, 2026. These are calendar-day calculations; they do not skip weekends or holidays.

For a list, place the first date in A2 and enter the plus-one formula in B2. Copy B2 down to apply it to the other rows. Excel adjusts the relative reference as it fills: the next row refers to A3, then A4, and so on. This is useful for due dates, daily logs, inspection schedules, or a simple sequence of dates.

How to enter and fill the calculation

Enter or select the starting date in a cell, such as A2. Check that Excel recognizes it as a date rather than plain text.
Select the result cell, such as B2, type the formula, and press Enter. The result should be one day after the date in A2.
To calculate more rows, select B2 and drag the small fill handle at the lower-right corner of the selection down the column. You can also copy B2, select the destination cells, and paste.
If you want to replace the original dates rather than calculate in a separate column, first make a backup or copy of the source data. A formula in the same cell cannot refer to its former value without creating a circular reference. One safe approach is to calculate in a spare column, copy the results, and use Paste Special > Values over the original dates.

Keeping the original date and the calculated date in separate columns makes the sheet easier to check. It also lets you see which starting value produced each result and correct an input without losing the source information.

Dates that include a time

Excel stores time as a fraction of a day. For instance, noon is half a day, or 0.5, after midnight. Consequently, adding 1 to a date-and-time value advances it by 24 hours and preserves the time of day. If A2 contains April 15, 2026 at 3:30 PM, the result is April 16, 2026 at 3:30 PM.

Sometimes you want the next calendar date but do not want to keep the time. With a date-and-time value in A2, enter =INT(A2)+1 in B2. INT removes the fractional time portion before adding a day. For example, an input of April 15, 2026 at 3:30 PM returns April 16, 2026 at midnight. Format B2 to display a date if you do not want to see the midnight time.

Be clear about what “one day later” means for your task. Adding 1 preserves the hour and minute, which is often right for a timestamp or appointment. Removing the time is more appropriate when you need a date-only value, such as a daily reporting date.

Calendar days versus working days

The plus-one method counts every calendar day. A Friday date plus 1 is Saturday, even if the date is a business deadline. For the next weekday, use WORKDAY instead. With a starting date in A2, enter =WORKDAY(A2,1) in B2. If A2 is Friday, April 17, 2026, the result is Monday, April 20, 2026.

WORKDAY treats Saturday and Sunday as weekends by default. If your organization observes a different weekend pattern, Excel also has WORKDAY.INTL, which lets you specify weekends; check the function’s arguments in your Excel version before using it. You can exclude holidays by supplying a range of holiday dates as the third argument. With the starting date in A2 and holiday dates in D2:D10, enter =WORKDAY(A2,1,D2:D10) in B2. The result skips weekends and any dates in that holiday range.

Use ordinary addition for a one-calendar-day notice period, a daily sequence, or an event that can fall on a weekend. Use a working-day function when the requirement specifically says business day. The two answers can differ, so choosing based on the wording of the rule matters more than choosing a shorter formula.

Formatting the result as a date

If the cell displays a value such as 46127 rather than April 16, the arithmetic may still be right. Excel is showing the date serial number with a General or Number format. Select the result cell, then choose Home > Number Format and select Short Date or Long Date. You can also right-click the cell, choose Format Cells, and select a date format from the Number tab.

Formatting changes how the value appears; it does not change the calculation. Short Date is compact, while Long Date spells out the weekday and month. If you need a custom display, Format Cells lets you choose a date pattern, such as a four-digit year or a month name. The best display depends on whether the sheet is for quick reading, printing, or data exchange.

A date can also look like a number because the destination cell inherited a numeric format from another part of the worksheet. Conversely, a cell may show only a time if its format hides the date portion. Changing the number format is usually the fix; do not add extra days to compensate for a display problem.

Common problems and how to diagnose them

The result is a serial number: Apply a date format to the result cell. A serial number is Excel’s stored date value, not automatically evidence of a bad formula.
The formula displays as text: The cell may be formatted as Text, or the entry may begin with an apostrophe. Change the cell to General, then re-enter the formula. A formula typed into a Text-formatted cell may not calculate merely because the format was changed afterward.
You get #VALUE!: The source may contain text that looks like a date rather than a recognized date value. Check the source cell and its regional date order. For example, 04/05/2026 can mean April 5 or May 4 depending on the locale. Re-enter the date in a form Excel recognizes for your settings, or convert the source data before calculating.
A blank source produces an unexpected date: Excel treats a blank cell used in arithmetic like zero, so adding 1 can display an early serial date. With the starting date in A2, enter =IF(A2="","",A2+1) in B2 to leave the result blank when A2 is blank. Otherwise, it returns the next day.
The date seems one day off: Check whether the source includes a time, whether the displayed format hides it, and whether the cell contains a true date. Also verify the workbook’s date system if values came from another workbook. Time-zone conversions in imported data can be another source of apparent shifts, although a normal worksheet date does not automatically apply a time zone.

When another date function is more appropriate

Adding 1 means exactly one day. It does not mean one month or the next business day. For a one-month shift, EDATE is designed to move a date by a specified number of months. With a starting date in A2, enter =EDATE(A2,1) in B2. If A2 is January 31, 2026, Excel returns February 28, 2026, because February has no 31st day. That behavior is different from adding 30 days, which may land in a different month.

For an adjustable number of calendar days, put the number in C2 and use a cell reference for it. With the starting date in A2 and the number of days in C2, enter =A2+C2 in B2. If C2 contains 10 and A2 is April 15, 2026, B2 returns April 25, 2026. This layout makes it easier to change the interval without editing the formula.

For a fixed date entered directly in a formula, a DATE function can avoid ambiguity between text date formats. With no source date required, enter =DATE(2026,4,15)+1 in A1; the result is April 16, 2026. DATE takes year, month, and day as separate numeric arguments. For an ongoing worksheet, a cell reference is generally easier to maintain than embedding a fixed date in the formula.

Frequently Asked Questions

What is the Excel formula to add one day to a date?
With the starting date in A2, enter =A2+1 in another cell. Format the result as a date if Excel displays a serial number.

Does adding 1 to a date include weekends?
Yes. It advances by one calendar day, so a Friday becomes Saturday. Use WORKDAY when the instruction means the next weekday and weekends should be skipped.

How do I add one day without changing the time?
With the date and time in A2, enter =A2+1 in B2. It preserves the time of day on the following calendar date. If you want midnight instead, use =INT(A2)+1.

Why does Excel show a number after I add a day?
Excel is likely showing the underlying serial value. Change the result cell’s number format to Short Date or another date format; the formula can remain unchanged.

How can I add one day to every date in a column?
Put the formula beside the first date, then fill it down. For example, with dates starting in A2, enter =A2+1 in B2 and copy or drag the formula down the rows.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.