To calculate a due date in Excel, add the number of calendar days to a valid start date: with the start date in A2 and the number of days in B2, enter =A2+B2. If A2 is January 10, 2026, and B2 is 30, Excel returns February 9, 2026; for a deadline measured in working days, use the WORKDAY function instead.
How Excel Calculates Dates
Excel stores dates as serial numbers, so adding a number to a date moves it forward by that many days. The cell may display a calendar date, while the underlying value is numeric. This is why ordinary addition works for simple deadlines and why a cell formatted as General may show a number instead of a date.
For a basic deadline, enter a real date in A2 and the number of days to add in B2. With those inputs in place, use =A2+B2. For example, January 10, 2026 plus 30 calendar days is February 9, 2026. The formula updates automatically if either input changes, which is useful when a project start date or response period is revised.
Check whether the rule counts the start date as day one. In ordinary date arithmetic, adding 30 means the date 30 days after the start date. If a policy defines the start date itself as day one of a 30-day period, the last day is usually 29 days after the start. The spreadsheet can calculate either convention, but it cannot determine which rule applies to a contract, policy, or internal process.
Calendar Days Versus Working Days
A calendar-day deadline includes Saturdays, Sundays, and holidays. A working-day deadline generally excludes weekends and may also exclude specified holidays. Choosing the wrong interpretation can shift a deadline by several days, so confirm what the source of the date requires before building a formula.
For a working-day deadline, put the starting date in A2, the number of workdays to add in B2, and any holiday dates in D2:D10. Use =WORKDAY(A2,B2,$D$2:$D$10). If A2 is Monday, February 2, 2026, B2 is 5, and there are no holidays in the interval, the result is Monday, February 9, 2026. WORKDAY treats Saturday and Sunday as weekends by default, and it does not count the start date as the first workday.
The holiday range is optional; if you do not maintain a holiday list, omit the third argument and use =WORKDAY(A2,B2). Enter holidays as actual Excel dates, not text that merely looks like a date. The dollar signs in the range lock it when copying the formula down a column, so every row continues to refer to the same holiday list.
To count the working days between two dates rather than calculate a future deadline, use NETWORKDAYS. With the start date in A2, the end date in B2, and holidays in D2:D10, enter =NETWORKDAYS(A2,B2,$D$2:$D$10). For February 2 through February 9, 2026, with no listed holidays, the result is 6 because both endpoints are included and the interval contains six weekdays. NETWORKDAYS is a duration/counting function; WORKDAY is the more direct choice when the goal is a due date.
Monthly Deadlines and Month-End Dates
When a deadline is one or more calendar months away, adding a fixed number of days is usually not equivalent. Months have different lengths, so a 30-day addition will not consistently land on the same day of the following month. Use EDATE to move a date by a specified number of months.
With the original date in A2 and the number of months to add in B2, enter =EDATE(A2,B2). If A2 is January 15, 2026, and B2 is 1, the result is February 15, 2026. EDATE also handles dates near the end of a month: moving January 31, 2026, forward one month returns February 28, 2026, the last valid day of February.
For a deadline that must fall on the final day of the next month regardless of the starting day, use EOMONTH. With the starting date in A2, enter =EOMONTH(A2,1). If A2 is January 15, 2026, the result is February 28, 2026. The second argument is the number of months to move before returning that month’s last date; zero returns the end of the date’s current month.
There is an important recurring-schedule distinction: EDATE applied repeatedly to a month-end date can shift the day-of-month pattern. For instance, January 31 moved forward one month becomes February 28, and moving that February date forward one month gives March 28. If a process requires every deadline to be the last day of its month, use an EOMONTH-based rule rather than repeatedly adding one month with EDATE.
Handling Nonstandard Weekends and Holidays
Some workplaces use weekend patterns other than Saturday and Sunday. WORKDAY.INTL lets you specify the weekend pattern while still skipping listed holidays. With a start date in A2, a workday count in B2, and holidays in D2:D10, use =WORKDAY.INTL(A2,B2,1,$D$2:$D$10) for the standard Saturday-Sunday weekend. The number 1 represents that default pattern.
For a Monday-to-Friday workweek where Saturday and Sunday are the weekend, the custom weekend string is Monday through Sunday, with 0 for a working day and 1 for a weekend day. With the same cell layout, the formula =WORKDAY.INTL(A2,B2,"0000011",$D$2:$D$10) specifies Saturday and Sunday as nonworking days. A code of 1 through 7 can also select predefined weekend patterns; consult Excel’s function help if the schedule differs, because the code determines which weekdays are skipped.
A holiday list should reflect the calendar relevant to the deadline, not just a generic list. A company closure, regional public holiday, or scheduled shutdown may affect one team but not another. Keep the dates in a clearly labeled range and update it when the governing schedule changes. If a holiday falls on a weekend and the organization observes it on a weekday, enter the observed weekday that actually affects the work schedule.
Entering Dates and Displaying Results
Excel must recognize the start date as a date value. A date typed in an ambiguous format can be interpreted differently depending on Windows regional settings—for example, a numeric day/month order may not mean the same thing on every computer. Use a consistent date convention, such as a clearly written month name, and verify the result before relying on a deadline. Imported dates can also arrive as text and fail in arithmetic.
To change how a calculated date appears, select the result cells and use Home > Number Format. Choose Short Date or Long Date, or open the Format Cells dialog with Ctrl+1 on Windows and select a date format. On Mac, Command+1 opens Format Cells. Formatting changes how the value is displayed, not the underlying due date. If the cell shows a large serial number, applying a date format often resolves the display issue.
For an unambiguous date built from year, month, and day components, use the DATE function. With the year in A2, month number in B2, and day number in C2, enter =DATE(A2,B2,C2). If the cells contain 2026, 1, and 10, respectively, the result is January 10, 2026. This can be useful when importing separate date components, though it does not by itself establish whether a deadline counts calendar or working days.
Building a Due-Date Tracker
A simple tracker is easier to maintain when each input has its own column. For example, use columns for task or reference, start date, day count, due date, and status. Put the due-date formula in the first data row and fill it down. Keep the source date and rule visible so another person can tell whether a deadline was calculated using calendar days, months, or working days.
To show a changing status, put the calculated due date in B2 and use =IF(B2="","",IF(B2<TODAY(),"Overdue",IF(B2=TODAY(),"Due today","Upcoming"))) in another cell. The formula returns a blank when B2 is blank, otherwise it labels dates before today as Overdue, today as Due today, and later dates as Upcoming. TODAY updates when Excel recalculates the workbook, so this is a live status rather than a permanent record of the status on the day the file was opened.
If a calculated date must remain fixed even when its inputs or the rules change, copy the result and use Paste Special > Values to replace the formula with its current value. Keep a copy of the original workbook or retain the input columns if you need to audit how the date was derived. A formula is generally preferable while the schedule is still changing; a fixed value is appropriate only when the workflow calls for a recorded, unchanging date.
Common Errors and Ways to Check Them
A formula that returns #VALUE! often points to a start date stored as text, a nonnumeric day count, or an invalid value in a referenced range. Confirm that the date is recognized by Excel and that the number-of-days cell contains a number. In a blank test cell, selecting the date and checking its number format can help distinguish a true date value from text.
Another frequent issue is an apparently incorrect result caused by a wrong deadline convention. Check whether the instruction says calendar days, business days, weeks, or months; check whether the starting day is included; and confirm which holidays count. A formula can be syntactically correct while implementing the wrong rule. For example, adding 30 is not the same as adding one month, and WORKDAY does not use a custom company calendar unless holidays are supplied.
When a result is one day earlier or later than expected, inspect the start-date inclusion rule and the weekend/holiday settings first. For working-day calculations, remember that WORKDAY advances from the start date and counts the subsequent workdays. For NETWORKDAYS, both the start and end dates count if they are workdays. These functions answer related but different questions, so substituting one for the other can cause off-by-one misunderstandings.
Before sharing a tracker, test a few known cases: a date near a month end, a deadline that crosses a weekend, and one that crosses a listed holiday. Check the formula bar for the formula and confirm that the output cells are date-formatted. If multiple people edit the workbook, label the holiday range and explain the applicable weekend pattern in a note or adjacent column.
Choosing the Right Formula
Choose the function based on the rule that defines the deadline, not on which formula looks shortest. The common options can be summarized as follows:
- Fixed number of calendar days: add the day count to the start date.
- Fixed number of working days: use WORKDAY, with a holiday range when needed.
- Nonstandard workweek: use WORKDAY.INTL and specify the weekend pattern.
- One or more calendar months later: use EDATE.
- Last day of a month: use EOMONTH.
- Count working days between dates: use NETWORKDAYS or NETWORKDAYS.INTL if the workweek is nonstandard.
For a deadline that must follow an external policy or agreement, verify the counting convention against that source. Excel calculates the rule you encode; it does not decide how a particular organization defines a day, recognizes a holiday, or handles a deadline that falls on a nonworking day.
Frequently Asked Questions
How do I add 30 days to a date in Excel?
Put the starting date in A2 and 30 in B2, then enter =A2+B2 in the result cell. Format the result as a date if Excel displays a serial number instead. This adds 30 calendar days, not 30 working days.
How do I calculate a due date excluding weekends?
Put the start date in A2 and the number of workdays in B2, then use =WORKDAY(A2,B2). This excludes Saturday and Sunday. Add a holiday range as the third argument if those dates should also be skipped.
How do I calculate a due date one month later?
With the start date in A2, use =EDATE(A2,1). It moves forward one calendar month and adjusts when the destination month has fewer days. Use EOMONTH instead if the required due date is always the last day of a month.
Why does Excel show a number instead of my due date?
Excel stores dates as numbers. Select the result cell and apply a date format from Home > Number Format, or open Format Cells and choose a date display. If formatting does not help, check whether the input was imported as text.
Does WORKDAY count the start date?
No. WORKDAY starts counting after the supplied start date, skipping weekends and any listed holidays. If your rule treats the start date as day one, account for that convention explicitly and verify the result against the applicable policy.
Related
- Excel Named Range Greyed Out? Causes and Fixes to Try
- Excel Named Range Lookup: Find and Use Named Ranges
- Budget vs Actual Excel Template: Build and Use One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Business Days: NETWORKDAYS and WORKDAY FormulasTo count weekdays between two dates in Excel, use =NETWORKDAYS(B2,B3); for example, with a Monday start date in…
- Excel Days Until Date: Formulas, Examples, and FixesTo calculate calendar days until a date in Excel, subtract today’s date from the target date: with the…
- How to Filter Purchases by Date in Excel, Step by StepTo filter purchases by date in Excel, select your purchase list, choose Data > Filter, open the arrow…
- Sort Excel Alphabetically: Rows, Columns, and ListsTo sort a list alphabetically in Excel for Microsoft 365 on Windows, select a cell in the column,…
- Excel Table Drag Formula: Lock Cell ReferencesTo keep a cell reference fixed when you fill a formula down an Excel table, add dollar signs…
- Show Formulas in Excel: Keyboard Shortcut GuideTo show formulas in Excel for Microsoft 365 on Windows, press Ctrl+` (Ctrl plus the grave accent key,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.