Work out business days excluding holidays instantly with clear inputs, formula shown and shareable results.
Business days are weekdays minus public holidays that fall on a weekday - holidays landing on a weekend cost nothing. From 5 January to 31 December 2026 there are 258 weekdays, so eight weekday holidays leave 250 business days, or 50 working weeks. That figure is the denominator for annual capacity planning.
Business days
business = weekdays in range - weekday public holidays
Working weeks
weeks = business days / 5
Because a holiday on a Saturday does not remove a working day. Some jurisdictions grant a substitute weekday, which should then be counted.
Typically 250-253 depending on how weekends and holidays fall - 260 weekdays minus eight to ten holidays.