How to Calculate Workday Due Dates in Excel and Google Sheets

All guides › Spreadsheets

Quick answer

Use WORKDAY for a Saturday and Sunday weekend, or WORKDAY.INTL for a custom workweek. Store holidays in a range of real date cells.

Business Days Calculator

Step by step

  1. Enter the starting date in A2, the signed workday offset in B2, and holiday dates in D2:D10. Format the result as a date.
  2. For a standard weekend, enter =WORKDAY(A2,B2,D2:D10). For a custom schedule, enter =WORKDAY.INTL(A2,B2,"0000011",D2:D10) and adjust the seven characters from Monday to Sunday. Use 1 for a day off and 0 for a workday.
  3. Use NETWORKDAYS or NETWORKDAYS.INTL to count eligible days between two dates. Use cell references or DATE values so the spreadsheet reads dates consistently.

Worked example

With November 6, 2026 in A2, 2 in B2, and November 9 in the holiday list, the standard weekend formula returns November 11.

Build a date worksheet with reproducible workday rules

Use WORKDAY or WORKDAY.INTL to return a target date. Use NETWORKDAYS or NETWORKDAYS.INTL to count eligible dates in a range. Write holidays as actual date values in a separate column.

Worked examples and expected results
ScenarioInputsCalculationResult
Plain next-week deadline2026-06-05, offset 2, Monday through Friday=WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10)2026-06-09
Skip a listed weekday holiday2026-06-05, offset 2, Monday through Friday, holiday 2026-06-08=WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10)2026-06-10
Count backwards2026-06-08, offset -2, Monday through Friday=WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10)2026-06-04
Use Friday and Saturday as days off2026-06-04, offset 2, Sunday through Thursday=WORKDAY.INTL(A2,B2,"0000110",$H$2:$H$10)2026-06-08
Use a Monday Wednesday Friday roster2026-06-01, offset 2, Monday, Wednesday, and Friday=WORKDAY.INTL(A2,B2,"0101011",$H$2:$H$10)2026-06-05
Check a longer offset2026-06-01, offset 10, Monday through Friday=WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10)2026-06-15

Plain next-week deadline

Write each part of the input on its own line before doing the calculation. This makes it easier to compare your work with the setup and to find the first place where your answer differs.

Inputs
2026-06-05, offset 2, Monday through Friday
Setup
Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday.
Calculation
=WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10)
Result
2026-06-09

Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-08, 2026-06-09. The last eligible date should agree with the formula.

Skip a listed weekday holiday

Try this case on your own using the method in the quick answer. Keep the original input in view while working. The intermediate calculation below gives you a checkpoint before you compare the final result.

Inputs
2026-06-05, offset 2, Monday through Friday, holiday 2026-06-08
Setup
Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday.
Calculation
=WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10)
Result
2026-06-10

Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-09, 2026-06-10. The last eligible date should agree with the formula.

Count backwards

Make a rough estimate first, using the size of the numbers and the units shown. A result that is off by a factor of sixty or by a whole date is often easier to spot with an estimate beside it.

Inputs
2026-06-08, offset -2, Monday through Friday
Setup
Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday.
Calculation
=WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10)
Result
2026-06-04

Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-05, 2026-06-04. The last eligible date should agree with the formula.

Use Friday and Saturday as days off

Do this example independently. Copy the complete inputs, including any labels that determine the interpretation. Then use the setup to decide which operation comes first and what the final answer should describe.

Inputs
2026-06-04, offset 2, Sunday through Thursday
Setup
Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday.
Calculation
=WORKDAY.INTL(A2,B2,"0000110",$H$2:$H$10)
Result
2026-06-08

Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-07, 2026-06-08. The last eligible date should agree with the formula.

Use a Monday Wednesday Friday roster

Use this case to check what happens at a boundary or when changing formats. Write the intermediate value separately from the displayed answer so you can tell whether a discrepancy comes from the calculation or from the presentation.

Inputs
2026-06-01, offset 2, Monday, Wednesday, and Friday
Setup
Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday.
Calculation
=WORKDAY.INTL(A2,B2,"0101011",$H$2:$H$10)
Result
2026-06-05

Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-03, 2026-06-05. The last eligible date should agree with the formula.

Check a longer offset

Save the original values and repeat the calculation using a different representation if one is available. Compare the intermediate result before rounding or formatting so you know whether the two approaches agree.

Inputs
2026-06-01, offset 10, Monday through Friday
Setup
Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday.
Calculation
=WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10)
Result
2026-06-15

Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-02, 2026-06-03, 2026-06-04, 2026-06-05, 2026-06-08, 2026-06-09, 2026-06-10, 2026-06-11, 2026-06-12, 2026-06-15. The last eligible date should agree with the formula.

Steps to check against your own records

  • Plain next-week deadline. Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-08, 2026-06-09. The last eligible date should agree with the formula.
  • Skip a listed weekday holiday. Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-09, 2026-06-10. The last eligible date should agree with the formula.
  • Count backwards. Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-05, 2026-06-04. The last eligible date should agree with the formula.
  • Use Friday and Saturday as days off. Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-07, 2026-06-08. The last eligible date should agree with the formula.
  • Use a Monday Wednesday Friday roster. Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-03, 2026-06-05. The last eligible date should agree with the formula.
  • Check a longer offset. Place the start date in A2 and the signed offset in B2. Put any date exclusions in H2:H10. The quoted mask represents Monday through Sunday. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-02, 2026-06-03, 2026-06-04, 2026-06-05, 2026-06-08, 2026-06-09, 2026-06-10, 2026-06-11, 2026-06-12, 2026-06-15. The last eligible date should agree with the formula.

Try the examples before revealing the answers

  1. Plain next-week deadline. 2026-06-05, offset 2, Monday through Friday. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
    Check the result

    =WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10) gives 2026-06-09. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-08, 2026-06-09. The last eligible date should agree with the formula.

  2. Skip a listed weekday holiday. 2026-06-05, offset 2, Monday through Friday, holiday 2026-06-08. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
    Check the result

    =WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10) gives 2026-06-10. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-09, 2026-06-10. The last eligible date should agree with the formula.

  3. Count backwards. 2026-06-08, offset -2, Monday through Friday. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
    Check the result

    =WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10) gives 2026-06-04. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-05, 2026-06-04. The last eligible date should agree with the formula.

  4. Use Friday and Saturday as days off. 2026-06-04, offset 2, Sunday through Thursday. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
    Check the result

    =WORKDAY.INTL(A2,B2,"0000110",$H$2:$H$10) gives 2026-06-08. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-07, 2026-06-08. The last eligible date should agree with the formula.

  5. Use a Monday Wednesday Friday roster. 2026-06-01, offset 2, Monday, Wednesday, and Friday. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
    Check the result

    =WORKDAY.INTL(A2,B2,"0101011",$H$2:$H$10) gives 2026-06-05. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-03, 2026-06-05. The last eligible date should agree with the formula.

  6. Check a longer offset. 2026-06-01, offset 10, Monday through Friday. Before revealing the answer, identify the unit you will work in and the unit you expect to report. Write your intermediate result alongside the original inputs.
    Check the result

    =WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10) gives 2026-06-15. Format the formula cell as a date. Check the sequence of eligible dates by hand: 2026-06-02, 2026-06-03, 2026-06-04, 2026-06-05, 2026-06-08, 2026-06-09, 2026-06-10, 2026-06-11, 2026-06-12, 2026-06-15. The last eligible date should agree with the formula.

Troubleshooting and checks

What do zero and one mean in the mask?

Zero marks a workday, and one marks an excluded day. The seven-character mask starts on Monday, so Saturday and Sunday off use 0000011. Preserve leading zeros by using a quoted string or a text cell.

How does a workday function differ from a range count?

A positive offset steps forward from the start date and generally does not count that date. A range count checks both endpoints for eligibility. To verify an offset by counting the resulting range, exclude the starting date when the offset is positive and the ending boundary when checking a backward offset from the original start.

Why do holidays seem to be ignored?

Check that the holiday range contains numeric date values that represent the expected dates. Test a single holiday with ISNUMBER and format the cell as a date to inspect it. A holiday on an already excluded weekday has no additional effect.

Sources

Calculation methodology · Report an error