In short
- State whether the start and end dates count.
- Define the weekend before subtracting holidays.
- Use the calendar required by the governing country, region, employer or contract.
Decide whether endpoints count
“Between dates” can be ambiguous. CalcQuick includes both endpoints by default when they are workdays, and the option can be turned off to exclude both. State the rule whenever a deadline or contract depends on the result.
Define the weekend
Saturday and Sunday are selected by default, but not every organization uses that schedule. Mark the weekdays your calendar treats as non-working so the same rule applies to both range counts and date shifts.
Read the date-range breakdown
The evaluated calendar-day total follows the endpoint setting. Weekend exclusions use the weekdays you selected, and holiday exclusions count only holidays that fall on an otherwise eligible weekday. This prevents a weekend holiday from being subtracted twice.
Add or subtract workdays
Use the date-shift mode to find a due date a whole number of workdays before or after a base date. The base date is not counted by default; enable the day-one option when your process explicitly includes it.
Add the holidays that apply
Holiday calendars vary by country, state, city, employer and industry. Enter applicable dates in YYYY-MM-DD format. A holiday on an already excluded weekend does not reduce the total again.
Check deadline rules
Legal, banking, payroll and delivery deadlines may define a business day differently. Confirm the governing rule before relying on a general calendar calculation.
Sources
These primary or official references support the formulas, definitions or scope used in this guide.
- NETWORKDAYS.INTL functionMicrosoft Support
- WORKDAY.INTL functionMicrosoft Support