Excel Due Date Formula: Examples and Workday Options

Formulas & functions · Updated November 20, 2026

For a basic due date in Excel, enter a start date in A2 and the number of calendar days to add in B2, then use =A2+B2. For example, a start date of January 15, 2026, plus 30 days returns February 14, 2026; use a workday function instead when weekends or holidays should be skipped.

How Excel Calculates a Due Date

Excel stores dates as serial numbers, so adding a whole number to a date moves it forward by that many calendar days. The formula returns a date value, not text. If the result looks like a number, apply a date format: select the result cell, then choose Home > Number Format and select Short Date or Long Date. You can also use Ctrl+1 on Windows to open Format Cells; on Mac, use Command+1.

For a basic calendar-day calculation, assume the start date is in A2 and the number of days to add is in B2. Enter =A2+B2 in C2. If A2 contains January 15, 2026, and B2 contains 30, C2 returns February 14, 2026. This counts forward 30 days from the start date; it does not count January 15 as day one.

That distinction matters when a policy says a period is due within a certain number of days and treats the start date as day one. In that case, the arithmetic may call for one fewer day, such as 29 days for a period of 30 days including the start date. Confirm the counting rule for the situation before choosing the number to add.

Choose the Formula That Matches the Deadline

Calendar-day deadlines and business-day deadlines are different. A simple addition includes every Saturday, Sunday, and holiday. A workday formula skips weekends, and an optional holiday list lets it skip specified dates as well. For monthly intervals, a month-based formula is usually a better fit than adding a fixed number of days.

Use these guidelines to select an approach:

  • Calendar days: Add the number of days directly when weekends and holidays count toward the deadline.
  • Business days: Use WORKDAY when a deadline is measured in working days and weekends are Saturday and Sunday.
  • Different weekends: Use WORKDAY.INTL to specify a weekend pattern, such as Friday and Saturday.
  • Whole months: Use EDATE when a deadline is one or more calendar months after a start date.
  • Recurring monthly dates: Use EOMONTH when the due date should fall at the end of a month.

Before building a larger schedule, decide what the source date represents, whether the start day counts, and how to handle nonworking days. A precise formula cannot resolve an unclear deadline rule on its own.

Calculate a Due Date in Business Days

WORKDAY advances a date by a number of working days, excluding Saturday and Sunday. It does not count the start date as the first working day. Assume the start date is in A2 and the number of business days to add is in B2. Enter =WORKDAY(A2,B2) in C2. If A2 is Monday, January 5, 2026, and B2 is 5, the result is Monday, January 12, 2026: Tuesday through Friday are four working days, and the following Monday is the fifth.

The same rule applies when the start date falls on a weekend: WORKDAY starts counting on the next eligible working day. If B2 is zero, the function returns the start date unless a holiday argument changes the result. Negative day counts are also allowed when you need to calculate backward from a date.

For work schedules with different weekend days, use WORKDAY.INTL. Assume A2 contains the starting date and B2 contains the number of working days to add. The formula =WORKDAY.INTL(A2,B2,1) uses weekend code 1, which means Saturday and Sunday. Other weekend codes are available, or a seven-character pattern can define working and nonworking days. In that pattern, 1 marks a nonworking day and 0 marks a working day, beginning with Monday. Check Microsoft’s function help for the code matching your actual schedule.

Exclude Holidays from the Calculation

WORKDAY and WORKDAY.INTL can also skip holidays supplied as dates in worksheet cells. Keep the holiday list as real Excel dates rather than text that merely resembles dates. For example, assume the start date is in A2, the number of working days is in B2, and holiday dates are in D2:D10. Enter =WORKDAY(A2,B2,D2:D10) in C2. If the start is Friday, January 16, 2026, B2 is 1, and D2 contains Monday, January 19, the formula returns Tuesday, January 20, because the weekend and listed holiday are skipped.

For a custom weekend schedule with the same holiday list, assume the inputs remain in A2 and B2 and holidays remain in D2:D10. Use =WORKDAY.INTL(A2,B2,1,D2:D10) to skip Saturday, Sunday, and the listed holidays. Replace weekend code 1 if your organization follows a different weekend pattern.

Holiday ranges can be made easier to maintain by placing the dates in a dedicated column with a clear heading. If the list grows, update the referenced range or use an Excel table and a structured reference. For a one-off calculation, a short fixed range is often sufficient. Confirm that the list contains only the holidays relevant to the people or location covered by the schedule.

Calculate Due Dates by Month

Adding 30 days is not the same as adding one month: months have different lengths. EDATE shifts a date by a chosen number of whole months and adjusts dates that do not exist in the destination month to that month’s final day. Assume the start date is in A2 and the number of months to add is in B2. Enter =EDATE(A2,B2) in C2. With January 31, 2026, in A2 and 1 in B2, the result is February 28, 2026.

Use EDATE for intervals such as one month after an invoice date or six months after a start date when the intended rule is a month interval. A date on the 30th or 31st can land on the last day of a shorter month. The next EDATE calculation uses the date in its start-date argument, so a recurring schedule may need a clearly defined anchor date if it must preserve a specific day of each month.

For a due date at the end of a month, assume A2 contains the reference date and B2 the number of months to move. Use =EOMONTH(A2,B2). If A2 is January 15, 2026, and B2 is 1, the result is February 28, 2026. EOMONTH returns the final calendar day of the target month; it does not automatically move that date to a business day.

Set Up a Reusable Due-Date Sheet

A small, consistent layout makes formulas easier to copy and audit. For example, use column A for the start date, B for the interval, and C for the calculated due date. Add descriptive headers in row 1, enter the first record in row 2, and place the chosen formula in C2. Use the fill handle to copy the formula down; Excel adjusts relative references for each row.

Use a date format for the start and due-date columns, and a whole-number format for a day or month interval. Avoid typing dates in ambiguous formats such as 03/04/26 when readers may interpret them differently. Select the cells and set a date format, or enter dates in a clear format that Excel recognizes for the workbook’s regional settings.

For a deadline that is always a fixed number of calendar days from the current date, assume the formula goes in A2. Enter =TODAY()+30. TODAY returns the current date according to Excel’s date system, so the result changes when the workbook recalculates on a later day. It is useful for a live rolling deadline, but not for a fixed historical record: once a date must remain unchanged, enter or preserve a fixed date instead of relying on TODAY.

When copying formulas, check that references point to the intended input cells. A reference such as A2 moves to A3 when filled down, which is normally useful. If a shared holiday list must remain fixed while copying, lock its reference with dollar signs; for example, change D2:D10 to $D$2:$D$10 in the formula. This prevents the holiday range from shifting to another row.

Common Errors and How to Fix Them

If a due date displays as a number, the calculation may still be correct: Excel is showing the underlying serial value. Format the result as a date. If a formula returns #VALUE!, check that the start date is an actual date value and the interval is numeric. Text pasted from another system can look like a date while remaining text, and spaces or unusual separators can prevent Excel from recognizing it.

If a result is one day earlier or later than expected, first check whether the start date should count as day one. Then confirm whether the deadline uses calendar days or working days. Also check whether the start date itself is a weekend or holiday and whether your chosen function includes or skips it according to the intended rule.

For business-day formulas, ensure each holiday cell contains a valid date and that the formula’s holiday range includes every relevant entry. Blank cells in a holiday range are generally ignored, but text entries are not reliable substitutes for dates. If formulas appear not to update, check Formulas > Calculation Options and confirm that calculation is set to Automatic when appropriate.

Another common misconception is that Excel knows a company’s holidays or a contract’s deadline rules automatically. It does not. A workday function skips the weekend pattern it is given and only skips holidays explicitly supplied in its holiday argument. The workbook owner must provide the right calendar and verify the rule behind the calculation.

Formula Options Compared

Each function answers a different question. Direct addition is the simplest choice for calendar-day intervals. WORKDAY handles standard Monday-to-Friday schedules, while WORKDAY.INTL supports alternative weekend patterns. EDATE shifts by calendar months, and EOMONTH returns a month’s last day. Choosing the function based on the deadline definition is more important than choosing the shortest formula.

For a list of invoices, for example, adding 30 calendar days may be appropriate if payment terms specify 30 days. If a service-level target is expressed as five business days, WORKDAY is more suitable. If rent is due one month after a date, EDATE may reflect the rule; if it is due on each month’s final day, EOMONTH is the relevant option. These examples illustrate spreadsheet mechanics, not a determination of what any agreement requires.

When an organization has a complex holiday calendar or multiple regional workweeks, maintain those calendar rules explicitly rather than assuming one formula fits every team. Document the weekend pattern, holiday source, and whether the start date counts. That makes a due-date column easier for another person to review and update.

Frequently Asked Questions

What is the simplest formula to add 30 days in Excel?
With the starting date in A2, use =A2+30. Format the result cell as a date. The formula adds calendar days, including Saturdays, Sundays, and holidays.

How do I add 30 business days in Excel?
With the start date in A2 and no holiday list, use =WORKDAY(A2,30). It skips Saturday and Sunday and does not count the start date as the first workday. Include a holiday range as the third argument when relevant.

How do I calculate a date one month later?
With the starting date in A2, use =EDATE(A2,1). EDATE shifts by one calendar month; if the target month has no matching day, the result is its last day.

Why does my due-date formula show a number?
Excel dates are stored as serial numbers. Select the result cell and apply a date format from Home > Number Format. The value may be a valid calculated date even when it is displayed numerically.

Does WORKDAY include the start date?
No. WORKDAY counts forward from the start date and treats the next eligible working day as day one. If your deadline rule counts the start date, adjust the interval only after confirming that convention.

Related

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.