Random Anvil

Date Calculator Excluding Sundays

For six-day working weeks: count the days between two dates with Sundays left out. Public holidays are optional, and you can exclude any other weekday instead if your day off is different.

Settings

Both boxes ticked = Excel's NETWORKDAYS. Untick "count the start date" to count days after today.

Holiday coverage and sources

National or federal rules only. UK means England and Wales. Regional, company and exceptional holidays may differ; add those in the custom box. This is a recurring-rule calculator, not a complete historical holiday archive.

Official references: US federal holidays · UK bank holidays · Australia by state and territory · Canada federal general holidays · Germany holiday calendar. Reference links checked October 14, 2026; this does not certify every historical or future date.

For Canada, this calculator uses next-weekday substitutes as a planning convention; employer schedules may use a different day.

Result

Holiday rules version . National / federal holidays only — add regional or company days in the custom box. Calculations run in your browser. Shared URLs include your settings; see the privacy page.

Days between two dates, without Sundays

Many workplaces — retail, construction, logistics, hospitality, and most businesses in India, the Middle East and parts of Asia — run a Monday-to-Saturday week. Standard business-day calculators assume a five-day week and give the wrong answer. This page counts every day except Sunday by default, so "how many working days between the 1st and the 30th" comes out right for a six-day schedule.

The result lists the calendar-day total, the number of Sundays removed, and any public holidays that were also excluded if you switched them on.

Example: six working days in one week

From October 5 to October 11, 2026, with both endpoints included and holidays off, there are 7 calendar days minus Sunday, October 11: 6 working days. Saturday counts. Excluding the start date changes the result to 5; excluding the Sunday end date does not change the working-day count. Try this example.

Other single-day weekends

If your day off is Friday (common in parts of the Middle East and North Africa) or Monday (hairdressers, restaurants, museums), tick that day instead of Sunday in the weekend box. Any combination of days can be excluded, so a Friday–Saturday weekend is one more tick away.

Adding public holidays

Tick "Exclude public holidays" to also remove the national holidays of the United States, United Kingdom, Canada, Australia or Germany. Holidays for other countries can be pasted into the custom box, one per line, either as full dates (2026-10-02) or as recurring month-day pairs (10-02).

Need a date instead of a count?

To find the date that is, say, 12 working days after a start date on a six-day week, use the add business days calculator with Sundays excluded. To count with a normal Saturday–Sunday weekend, use the business days calculator.

Frequently asked questions

Does this count Saturdays as working days?

Yes. By default only Sunday is excluded. Tick Saturday too if you want a five-day week.

Can I exclude Fridays instead of Sundays?

Yes — untick Sunday and tick Friday. Any weekday can be treated as the weekend.

Are public holidays excluded?

Not by default on this page. Turn on "Exclude public holidays" and pick a country, or add dates in the custom box.