Working days calculator with public holidays

Count the working days between two dates, both included, with weekends and one country's public holidays left out. The dates you enter stay in your browser.

What WORKDAYS and NETWORKDAYS leave out

monday.com's WORKDAYS formula counts working days by the account's work week, Monday to Friday or Sunday to Thursday, and monday.com's formula articles describe no way to give it a list of public holidays; the WORKDAYS formula guide has the details. A spreadsheet's NETWORKDAYS can skip holidays, but only from a list someone types in and keeps up to date every year. In May 2026, Germany has three public holidays on weekdays: a count that ignores them is three days too long.

Working days on a monday.com board

Stale & SLA counts time in status, days since the last activity and SLA targets in working days of each board's calendar: its time zone, work days, working hours and holidays. Read the guide to working days and holidays on monday.com, or try the app on sample data.

For a deadline rather than a count, the SLA deadline calculator adds working hours or days to a start time; for the hours between two moments, use the business hours calculator. For a federal FOIA response, the FOIA deadline calculator counts the 20 working days, and for a UK data protection request the DSAR deadline calculator counts the one calendar month. To work back from a deadline to the last day to start, use the start date calculator.

Frequently asked

Are both dates counted?

Yes. Monday to Friday of one week is 5 working days.

Which holidays are left out?

The public holidays of the country you choose: the US federal holidays, the bank holidays of England and Wales, the holidays observed across all of Germany, the French public holidays, Israel's holidays from the Hebrew calendar, Romania's statutory holidays with Easter and Rusalii on the Orthodox dates, Poland's statutory days off (Christmas Eve included from 2025), Italy's national holidays (San Francesco on 4 October from 2026), the days Spain keeps in every region, or the Dutch national holidays. The Dutch list includes Liberation Day on 5 May, which many collective agreements give as a day off only every fifth year. Regional and local holidays, such as those of a single German state, a Spanish region or an Italian city's patron saint, are not included. Each country's current rules are applied to every year, apart from the start years named here, so for dates long past, check the list that was in force then.

What if a holiday falls on a weekend?

It is counted once, as a weekend day. Where the law moves it to a weekday, as with US observed days and UK substitute days, that weekday is left out instead. Spain's regional Monday replacements and Poland's extra day off for a Saturday holiday depend on the region or the employer, so they are not included.

Does monday.com's WORKDAYS formula skip holidays?

monday.com's formula articles show WORKDAYS with two dates and no holiday list, and a monday.com community feature request reports that it does not recognize the holidays in the account calendar. Test a range that spans a holiday. This calculator leaves the chosen country's public holidays out.

Are the dates sent anywhere?

No. The count runs in your browser, and the dates you enter stay there.