In Excel, use =TODAY()+1 to return tomorrow’s date. Enter it in a cell and format that cell as a date if Excel displays a number instead of a calendar date.
The Basic Formula
With the result going in any empty cell, enter =TODAY()+1. The formula has two parts: TODAY() returns the current date, and adding 1 advances that date by one day. For example, if Excel’s current date is June 14, the result is June 15. The formula works across month ends and year ends, so a date on December 31 advances to January 1 of the following year.
TODAY is a built-in Excel function that takes no arguments, so its parentheses stay empty. The plus sign and 1 perform date arithmetic: Excel treats a date as a serial number, with each whole-number step representing one day. You do not need to use a separate function for tomorrow or manually account for the number of days in a month.
To enter the formula, select a cell, type it beginning with an equals sign, and press Enter. In Excel for Microsoft 365 on Windows, the same formula works in desktop Excel and Excel for the web. There is no different tomorrow-date formula required in the Mac version.
How Excel Calculates Tomorrow
Excel stores dates as numbers and displays them according to the cell’s number format. The underlying value is useful because adding or subtracting whole numbers can move a date forward or backward by days. The formula adds one to the current date value, rather than adding the text “tomorrow” or calculating a date from the month name.
This date arithmetic also handles calendar details for you. If today is the last day of a month, adding one produces the first day of the next month. In a leap year, moving from February 28 to the next day produces February 29; in a non-leap year, it produces March 1. The result is determined by Excel’s date system and the date returned by the computer, not by a hand-written list of month lengths.
Excel workbooks can use either the 1900 or 1904 date system, depending on the workbook and its history. Ordinary date formulas such as =TODAY()+1 work in either system. Differences between date systems matter most when dates are transferred between workbooks as raw serial values, not when you simply calculate tomorrow inside one workbook.
Format the Result as a Date
If the formula displays a number such as 45,000 rather than a date, it has usually calculated correctly: the cell is displaying the underlying serial number. Change the number format rather than changing the formula. Select the result cell, then choose Home > Number Format and select Short Date or Long Date. The exact appearance depends on your regional settings.
Short Date might show a compact numeric date, while Long Date typically includes the weekday and spells out the month. Formatting changes how the value looks, not the date stored in the cell. That distinction matters when another formula needs to compare the result, sort dates, or calculate a deadline.
You can also use a custom date format if the built-in choices do not suit your worksheet. Select the cell and open the Format Cells dialog, then choose the date or custom category and select an available format or enter a pattern. For example, a format that includes weekday, month, and day can make a planning sheet easier to scan. Avoid typing a date-looking result as plain text if you need Excel to use it in calculations.
When the Formula Updates
TODAY() is a volatile function: Excel recalculates it when the workbook recalculates. That means the displayed result is dynamic, not a permanent record of the date on which you first entered the formula. In normal automatic calculation mode, Excel recalculates formulas as needed, including when the workbook is opened or relevant changes trigger calculation. It does not act like a clock that visibly changes the cell at every moment.
If the result still shows yesterday after midnight, check whether calculation is set to automatic. In Windows Excel, use Formulas > Calculation Options > Automatic. Calculation settings can affect the workbook’s behavior, so changing the setting may recalculate other formulas too. Pressing F9 requests a calculation in Excel for Windows; on Mac, the calculation shortcut can depend on the keyboard and function-key settings, so the Formulas tab is a straightforward option.
The result also depends on the current date available to Excel through the device or environment running the workbook. If the computer’s date is wrong, the formula can return the wrong “today,” and therefore the wrong tomorrow. If a workbook is opened on another device or in Excel for the web, the date used may reflect that environment rather than the computer where the formula was first entered.
Dynamic Formula or Fixed Date?
Use =TODAY()+1 when the cell should always mean one day after the current date. That is useful for a rolling reminder, a daily planning sheet, or a dashboard that should show the next calendar day whenever it recalculates. It is not the right choice for preserving a date that must remain unchanged for an audit trail, a completed transaction, or a dated entry.
For a fixed date, insert the current date as a value instead of using a formula. In Excel for Windows, press Ctrl+; (Control plus semicolon) to enter today’s date in the selected cell. In Excel for Mac, Control+; is commonly used for the same action; keyboard layouts and system shortcuts can vary. The inserted value will not roll forward tomorrow. If you need a fixed date other than today, type that date into a cell and confirm Excel recognizes it as a date.
A formula that refers to a fixed date stored elsewhere can be useful when a schedule is based on a known start date. With a real starting date in A2 and the result in B2, use =A2+1. This returns the day after the date in A2, regardless of the current date. If A2 is blank or contains text that Excel does not recognize as a date, the result may not be what you expect.
Readable Labels and Other Useful Variations
For a worksheet label that should include the weekday and a long-form date, you can turn tomorrow’s value into formatted text. With the label going in an empty cell, use =TEXT(TODAY()+1,"dddd, mmmm d, yyyy"). If today is June 14, the displayed text is “Sunday, June 15, 2025” only when that date’s weekday and year match the actual calendar; the example date should always be checked for its year before using it. The format codes request a full weekday name, full month name, day number, and four-digit year.
This variation has an important limitation: TEXT returns text, not a date value. It is suitable for a heading or message, but a date-formatted result from the basic formula is generally better for sorting, date comparisons, and further date calculations. Regional settings may also affect how date names and separators appear.
For a deadline that is a fixed number of days after a date in a worksheet, use the date in a cell as the starting point. With the starting date in A2 and the number of days to add in B2, enter =A2+B2 in C2. If A2 contains June 14 and B2 contains 1, C2 returns June 15. This is more flexible than hard-coding 1 when the number of days varies by row.
Common Problems and Checks
- The cell shows a number: Apply a date format through Home > Number Format. The serial number is often the correct calculation displayed in a general or numeric format.
- The formula appears as text: Check that the cell is not formatted as Text and that the entry begins with
=. Change the format to General, then re-enter the formula; changing the format alone may not convert an existing text entry. - The date seems one day behind or ahead: Check the device’s date and the workbook’s calculation mode. Also confirm whether you intended a dynamic result or a fixed date.
- The result does not change when expected: Recalculate the workbook or set Formulas > Calculation Options > Automatic. Remember that the formula updates on calculation; it is not a continuously running timer.
- A formula with a starting date fails: Confirm that the source cell contains a genuine Excel date value, not text that merely looks like a date. Re-enter the date in a recognized format if needed.
These checks help distinguish a calculation problem from a display problem. A date can be stored correctly but shown as a serial number, or it can look like a date while actually being text. If you plan to sort or calculate with the result, verify that Excel recognizes it as a date value.
Frequently Asked Questions
Does =TODAY()+1 update automatically tomorrow? It updates when Excel recalculates the workbook. With automatic calculation enabled, it normally refreshes during routine recalculation and when the workbook is opened. It does not necessarily change at the exact stroke of midnight while the workbook remains idle.
What is the formula for tomorrow’s date in Excel? The standard formula is =TODAY()+1. It returns a date value one day after the current date used by Excel. Format the result cell as a date if it appears as a number.
How do I show tomorrow’s weekday as well as the date? Keep the result as a date and apply a date format that includes the weekday, or use the TEXT variation above for a text label. Keeping a real date value is preferable if you will sort it or use it in calculations.
How do I enter tomorrow’s date so it stays fixed? Insert a date value rather than a formula: use the current-date shortcut and adjust the value if necessary, or type the required date directly. A fixed value does not advance when the workbook recalculates.
Can I calculate the day after a date in another cell? Yes. If the starting date is in A2, the date arithmetic variation =A2+1 returns the following day. Make sure A2 contains a valid date value and format the result cell as a date.
Related
- Excel Data Analysis Toolkit: Setup, Tools, and Practical Uses
- Excel Data Analysis Sampling: Methods, Steps, and Uses
- Excel Data Analysis Skills: What They Include and Why
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Switch Excel Formulas to Values: Methods and TipsTo switch formulas to fixed values in Excel for Microsoft 365 on Windows, select the formula cells, press…
- Excel AND in MATCH: Find Rows With Multiple CriteriaTo use AND conditions with Excel MATCH, compare each criteria range with its requested value and multiply the…
- Median Formula Examples in Excel and by HandThe median is the middle value after a set of numbers is arranged from smallest to largest; with…
- Excel Lookup Formula Examples for Common TasksExcel lookup formulas find a value in one range and return a related value from another. In Microsoft…
- Excel Formula for Time Clock Hours In and Out by ShiftFor clock-in time in A2 and clock-out time in B2, enter =MOD(B2-A2,1)*24 to return the shift length as…
- How to Count Unique Values in an Excel PivotTableTo count distinct values in an Excel PivotTable, create the PivotTable with Add this data to the Data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.