WhenMathFirst / Last Business Day of Period
Find the first and last working day within a date range, using whichever days of the week you consider working days. This checks the workweek only; it does not exclude holidays (see the holiday-aware engines for that).
Worked example
For January 2027 (which starts on a Friday) with a Monday-Friday workweek, the first business day of the month is January 1 itself (a Friday), and the last is January 29 (also a Friday), since January 31 falls on a Sunday.
Limitations
This checks the selected workweek only; it does not exclude public holidays. For that, see Business Days & Work Calendar's holiday-aware engines.
Frequently asked questions
- Does this exclude holidays?
- No, this engine only checks which days of the week count as working days; holiday exclusion is handled by other engines in Business Days & Work Calendar.