Quick answer
For a nonzero workday offset, start on the following or preceding date. Count only days in your work schedule that are outside your holiday list.

Step by step
- Choose the starting date and direction. Use the workweek that applies to the task. For example, your schedule might run Sunday through Thursday.
- Write holidays and observed days off as dates. If a holiday already falls on a weekend, it is skipped once.
- Move one date at a time until you reach the requested number of eligible dates. For a date range, decide separately whether each endpoint can count.
Worked example
Start Friday, November 6, 2026. Skip Saturday, Sunday and a Monday holiday. Tuesday is workday one and Wednesday, November 11 is workday two.
Walk forward or backward through eligible business dates
Use the original date as day zero. For a nonzero offset, start counting on the following or preceding date, skipping every unselected weekday and holiday. Zero keeps the original date.
| Scenario | Inputs | Calculation | Result |
|---|---|---|---|
| Move forward from Friday | 2026-06-05, offset 2, Monday through Friday, no holidays | 2026-06-08 → 2026-06-09 | 2026-06-09 |
| Skip a holiday Monday | 2026-06-05, offset 2, Monday through Friday, holiday 2026-06-08 | 2026-06-09 → 2026-06-10 | 2026-06-10 |
| Move backward across a weekend | 2026-06-08, offset -2, Monday through Friday, no holidays | 2026-06-05 → 2026-06-04 | 2026-06-04 |
| Use a Tuesday–Saturday schedule | 2026-06-05, offset 2, Tuesday through Saturday, no holidays | 2026-06-06 → 2026-06-09 | 2026-06-09 |
| Start from a non-working date | 2026-06-07, offset 1, Monday through Friday, no holidays | 2026-06-08 | 2026-06-08 |
| Keep the starting date | 2026-06-07, offset 0, Monday through Friday, no holidays | No movement for zero | 2026-06-07 |
Move forward from Friday
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, no holidays
- Setup
- Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign.
- Calculation
- 2026-06-08 → 2026-06-09
- Result
- 2026-06-09
The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
Skip a holiday Monday
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
- Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign.
- Calculation
- 2026-06-09 → 2026-06-10
- Result
- 2026-06-10
The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
Move backward across a weekend
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, no holidays
- Setup
- Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign.
- Calculation
- 2026-06-05 → 2026-06-04
- Result
- 2026-06-04
The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
Use a Tuesday–Saturday schedule
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-05, offset 2, Tuesday through Saturday, no holidays
- Setup
- Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign.
- Calculation
- 2026-06-06 → 2026-06-09
- Result
- 2026-06-09
The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
Start from a non-working date
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-07, offset 1, Monday through Friday, no holidays
- Setup
- Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign.
- Calculation
- 2026-06-08
- Result
- 2026-06-08
The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
Keep the starting date
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-07, offset 0, Monday through Friday, no holidays
- Setup
- Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign.
- Calculation
- No movement for zero
- Result
- 2026-06-07
The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
Steps to check against your own records
- Move forward from Friday. Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
- Skip a holiday Monday. Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
- Move backward across a weekend. Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
- Use a Tuesday–Saturday schedule. Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
- Start from a non-working date. Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
- Keep the starting date. Do not count the starting date toward a nonzero offset. Follow the actual schedule in the direction indicated by the sign. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
Try the examples before revealing the answers
- Move forward from Friday. 2026-06-05, offset 2, Monday through Friday, no holidays. 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
2026-06-08 → 2026-06-09 gives 2026-06-09. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
- Skip a holiday Monday. 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
2026-06-09 → 2026-06-10 gives 2026-06-10. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
- Move backward across a weekend. 2026-06-08, offset -2, Monday through Friday, no holidays. 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
2026-06-05 → 2026-06-04 gives 2026-06-04. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
- Use a Tuesday–Saturday schedule. 2026-06-05, offset 2, Tuesday through Saturday, no holidays. 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
2026-06-06 → 2026-06-09 gives 2026-06-09. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
- Start from a non-working date. 2026-06-07, offset 1, Monday through Friday, no holidays. 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
2026-06-08 gives 2026-06-08. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
- Keep the starting date. 2026-06-07, offset 0, Monday through Friday, no holidays. 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
No movement for zero gives 2026-06-07. The sequence lists only eligible days encountered. An offset of zero is an instruction to return the starting date, even when that date would otherwise be excluded.
Troubleshooting and checks
How do you handle an endpoint on a day off?
Leave the original endpoints in the range. Then count each endpoint only if its weekday is selected and it is not a holiday. Moving a boundary manually can change the result for custom schedules, especially when a weekend is different from Saturday and Sunday.
Can a holiday count twice as an exclusion?
A date is either eligible or excluded. A holiday on an already excluded weekday does not reduce the total again. Keep one entry per holiday date so your worksheet can be inspected and avoid subtracting a holiday total separately from an already filtered result.
How is this different from finding a due date?
The count mode answers how many eligible dates fit inside a range. A positive offset walks forward from the day after the start. For example, if Monday is a workday, an inclusive Monday-to-Monday range contains one workday, while one business day after Monday is the next eligible date.