To calculate a date a set number of days from today, enter =TODAY()+30 in any blank cell, such as B2, to return the date 30 days ahead. Use a minus sign to count backward. Excel updates TODAY automatically when the workbook recalculates, so these dates stay relative to the current day. You will need a working Excel workbook and, for some examples, a cell containing a date you want to compare with today.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows. The formulas also work in current Excel for Mac and Excel for the web.
- A blank worksheet cell for each result.
- For dates calculated from another date, a cell containing a valid Excel date. For workday calculations, you may also want a list of holiday dates.
Excel stores dates as serial numbers and displays them using a date format. That means date calculations are arithmetic under the surface, even when cells show familiar calendar dates. The formulas below use commas between arguments, as required in standard English-language Excel settings. Regional settings can affect how typed dates are interpreted, so the DATE function is a reliable way to build a specific date.
Step-by-Step
-
Choose what you want to calculate. Decide whether you need a date a number of calendar days away, a date several months away, a deadline based on working days, or the number of days between today and an existing date. Calendar-day calculations include weekends and holidays. Workday calculations treat weekends differently, so choose the method that matches your deadline.
-
Enter a basic date offset. Click a blank cell, such as B2. With the result in B2, enter
=TODAY()+30to add 30 calendar days to today. With the same cell layout, enter=TODAY()-14instead to find the date 14 calendar days ago. The first formula returns a date 30 days ahead and the second a date two weeks earlier. For example, if today is November 3, 2026, the results are December 3, 2026, and October 20, 2026. Replace 30 or 14 with the number of days you need.The plus and minus signs are important: adding a positive number moves forward, while subtracting one moves backward. You can also use a cell to hold the offset. If B2 contains the number of days, then in C2 enter
=TODAY()+B2. When B2 is 30, C2 returns a date 30 days ahead. This makes it easy to adjust the interval without editing the formula itself. -
Calculate how many days remain until a date. Put the target date in B2 and enter
=B2-TODAY()in C2. If B2 is December 3, 2026, and today is November 3, 2026, C2 returns 30. A positive result means the target is in the future, zero means it is today, and a negative result means it has passed. Format C2 as a number if Excel displays the result as a date; the calculation is a count of days, not a calendar date.For a dependable test date, enter a date using a format Excel recognizes in B2, or create it with a date formula. With B2 as the target-date cell, enter
=DATE(2026,12,3)to set it to December 3, 2026. DATE takes the year, month, and day in that order, avoiding confusion between regional day-first and month-first date formats. -
Move forward by months rather than a fixed number of days. Adding 30 days is not the same as adding one calendar month, because months have different lengths. With the result in B2, enter
=EDATE(TODAY(),3)to return the date three months from today. If today is November 3, 2026, the result is February 3, 2027. Change 3 to another positive number for future months or use a negative number for past months.EDATE keeps the day of the month where possible. If the target month does not have that day, Excel returns the last valid day of that month. For example, adding one month to January 31 returns the last day of February. If you instead need the first day of next month, put the result in B2 and enter
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1). On November 3, 2026, this returns December 1, 2026. DATE handles the month rollover when the month number becomes 13. -
Skip weekends for a working-day deadline. With the result in B2, enter
=WORKDAY(TODAY(),10)to find the date 10 working days after today. WORKDAY treats Saturday and Sunday as weekend days and does not count today as one of the 10 days. If today is Tuesday, November 3, 2026, and there are no holidays to exclude, the result is Tuesday, November 17, 2026. This is useful for a processing period or a business-day turnaround that starts today.To exclude holidays as well, list actual Excel dates in F2:F10, with one holiday per cell. With the result in B2 and holidays in F2:F10, use
=WORKDAY(TODAY(),10,$F$2:$F$10). The dollar signs keep the holiday range fixed if you copy the formula elsewhere. Confirm the holiday list covers the full period being calculated; an omitted holiday will be treated as a normal working day. -
Count working days between today and a date. Put the end date in B2 and enter
=NETWORKDAYS(TODAY(),B2)in C2. NETWORKDAYS counts weekdays from the start date through the end date, including either endpoint if it falls on a weekday. If today is November 3, 2026, and B2 is December 3, 2026, the result is 22 weekdays. To exclude holidays listed in F2:F10, enter=NETWORKDAYS(TODAY(),B2,$F$2:$F$10)instead. A past end date can produce a negative count. -
Format the result so it is readable. Select a cell containing a date, then choose Home > Number Format and select Short Date or Long Date. If a date formula displays a number such as 46329, the calculation may be correct: Excel is showing the stored serial number rather than a date style. Apply a date format to show it as a calendar date. If the result is a day count, format it as General or Number instead.
In Excel for Mac, use the Home tab and its number format controls in the same way; the ribbon layout may differ slightly by window size. Excel for the web also supports these formulas and date formats from the Home tab. The formulas themselves do not need to change between Windows, Mac, and the web.
-
Check whether the date should update. TODAY returns the current date when Excel recalculates the workbook. If you need a date that never changes, do not use TODAY: insert a fixed date instead. On Windows, Ctrl+; inserts the current date as a fixed value in the selected cell. On Mac, Control+; is the corresponding shortcut in Excel. A fixed value will not roll forward tomorrow, unlike a formula using TODAY.
Common Mistakes
-
Using a fixed day count for a month. Adding 30 days does not reliably mean the same calendar day next month. Use EDATE when the requirement is expressed in months, and use a day offset only when the number of days is what matters.
-
Confusing a date with a day count. A formula that subtracts TODAY from a target date returns a number of days. If the cell is formatted as a date, that number can look like an unrelated date. Set the result to General or Number.
-
Typing a date Excel reads differently than intended. A value such as 04/05/2026 could mean April 5 or May 4 depending on regional settings. Use DATE with year, month, and day arguments, or check the cell after entry to confirm Excel interpreted it correctly.
-
Expecting WORKDAY to count today. WORKDAY starts counting after its start date. If the process should include today, check the business rule and adjust the number of workdays accordingly. NETWORKDAYS, by contrast, includes weekday endpoints in its count.
-
Overlooking time values. A cell can contain both a date and a time, even if only the date is visible. This may cause a comparison or count to behave unexpectedly. If the source should be date-only, remove the time component or use a clean date value in a helper column.
Tips
-
Keep the number of days or months in a separate input cell when you expect to change it. Label the cell clearly, such as Days to add, and use a cell reference in the formula.
-
Use absolute references for a holiday range, as in $F$2:$F$10, before copying WORKDAY or NETWORKDAYS formulas down a column. Otherwise, the range can shift and stop including some holidays.
-
For a schedule, enter the starting date once and use fill handle or copy and paste to extend related calculations. Check a few copied rows to confirm the references point to the intended inputs.
-
Remember that TODAY is volatile: it can recalculate when Excel recalculates the workbook, not only at midnight. If you are preparing a report that must preserve the date used, copy the result and use Paste Special > Values, or insert a fixed date.
-
Use descriptive headings such as Due date, Days remaining, or Business-day deadline. Clear labels help distinguish a calendar date from a number of days.
Troubleshooting
The cell shows a large number instead of a date: Select the cell and choose Home > Number Format > Short Date. If the cell should show elapsed days, choose General or Number instead. Changing the display format does not alter the stored calculation.
The formula appears as text or does not calculate: Check that the cell does not have the Text number format. Change it to General, edit the cell, and confirm the entry begins with an equals sign. Also check for a leading apostrophe or extra spaces before the formula. Press Enter after correcting it.
The result is not changing when the day changes: Confirm the cell contains a formula using TODAY rather than a date typed as a value. On Windows, check Formulas > Calculation Options > Automatic. If calculation is set to Manual, change it to Automatic or recalculate the workbook. Mac versions have calculation controls on the Formulas tab; the exact layout can vary. Excel for the web generally recalculates supported formulas automatically.
WORKDAY returns a date that seems too early or late: Check the starting date, the number of workdays, and whether a holiday range was included. Verify that the holiday cells contain real dates rather than text, and remember that Saturdays and Sundays are skipped by default. The standard WORKDAY function does not configure custom weekend days; use WORKDAY.INTL if your schedule has a different weekend pattern.
A formula returns an error or an unexpected count: Make sure the referenced cells contain valid dates, not text that only looks like a date. Check that the start and end dates are in the intended order, and that the holiday range contains only dates or blank cells. If your Excel uses a different regional list separator, it may require semicolons instead of commas when you type formulas; use the separator configured for that installation.
Frequently Asked Questions
How do I calculate tomorrow in Excel?
In a blank cell, add one calendar day to TODAY. The result updates with the workbook date and will show tomorrow whenever Excel recalculates on a later day.
How do I calculate yesterday in Excel?
Subtract one calendar day from TODAY. The result is a date, so apply a date format if Excel displays a serial number.
How do I add a month to today?
Use EDATE with TODAY as the start date and 1 as the number of months. This moves by a calendar month rather than adding a fixed 30-day interval. If the destination month is shorter, EDATE uses its final day.
Does TODAY update automatically?
TODAY updates when Excel recalculates the workbook. Automatic calculation is the usual setting, but a workbook set to Manual may keep an older result until recalculated. TODAY returns a date only, not the current time.
Can I keep the date from changing?
Yes. Insert the current date as a fixed value using Ctrl+; on Windows or Control+; on Mac, or replace a TODAY formula result with its value. A fixed date is useful for a dated record, while TODAY is better for a live schedule.
How do I calculate a deadline that skips weekends?
Use WORKDAY with today as the starting date and the number of working days to add. Add a holiday-date range if public or company holidays should also be skipped, and confirm the weekend convention matches your schedule.
Related
- Excel Cell Alignment Shortcuts: A Step-by-Step Guide
- How to Add Weekly Dates in Excel
- Add a White Background and One Border in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Align Left Shortcut: Windows and Mac GuideIn Excel for Microsoft 365 on Windows, select the cell or range and press Alt, then H, A,…
- Excel Formula for Last Updated Date in a Specific CellFor a live current date in Excel, use =TODAY(); for the current date and time, use =NOW(). Neither…
- How to Add IFERROR in Excel to Handle Formula ErrorsTo add IFERROR in Excel, wrap your existing formula inside IFERROR and specify what to show if that…
- Count Words in Excel: Formulas for Exact and Partial MatchesTo count every occurrence of a word across text in Excel, put the word to find in D1…
- Excel VLOOKUP Using Two Sheets: Steps and ExamplesTo use VLOOKUP across two sheets in the same Excel workbook, enter a formula that names the source…
- Insert a Horizontal Page Break in Excel the Right WayTo insert a horizontal page break in Excel for Microsoft 365 on Windows, select the row directly below…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.