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.

Step by step
- Enter the starting date in A2, the signed workday offset in B2, and holiday dates in D2:D10. Format the result as a date.
- 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. - Use
NETWORKDAYSorNETWORKDAYS.INTLto 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.
| Scenario | Inputs | Calculation | Result |
|---|---|---|---|
| Plain next-week deadline | 2026-06-05, offset 2, Monday through Friday | =WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10) | 2026-06-09 |
| Skip a listed weekday holiday | 2026-06-05, offset 2, Monday through Friday, holiday 2026-06-08 | =WORKDAY.INTL(A2,B2,"0000011",$H$2:$H$10) | 2026-06-10 |
| Count backwards | 2026-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 off | 2026-06-04, offset 2, Sunday through Thursday | =WORKDAY.INTL(A2,B2,"0000110",$H$2:$H$10) | 2026-06-08 |
| Use a Monday Wednesday Friday roster | 2026-06-01, offset 2, Monday, Wednesday, and Friday | =WORKDAY.INTL(A2,B2,"0101011",$H$2:$H$10) | 2026-06-05 |
| Check a longer offset | 2026-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
- 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. - 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. - 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. - 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. - 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. - 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.