Business Days & Public Holidays (200+ countries)

A business days calculator and public holiday API for more than 200 countries, with regional calendars (US states, German Länder, Australian states, Canadian provinces and more). Ask it which holidays fall in a year, how many working days sit between two dates, what date is N working days from now, or when an SLA clock runs out.

Useful for invoice due dates, delivery promises, SLA tracking, payroll and scheduling, and for filling a spreadsheet with a country's holidays without maintaining the list yourself.

What you get

One row per holiday or per calculation, depending on mode.

Mode	Answers	Row example
holidays	Which public holidays fall in a country and year	2026-02-16, Washington's Birthday, local name Presidents Day, types ["public"]
businessDaysBetween	Working days between two dates	2026-01-01 to 2026-03-31: 89 days, 60 business days, 26 weekend days, 3 holidays
addBusinessDays	The date N working days after (or before) a date	2026-12-24 + 5 = 2027-01-04, skipping 4 weekend days and 2 holidays
sla	When a deadline expires in working days or hours	start 2027-03-25T16:40+01:00, 2 working hours, deadline 2027-03-30T10:40+01:00

Weekends and public holidays are excluded from every calculation. Every row carries country and region.

How to use it

Holidays for a few countries:

{
  "mode": "holidays",
  "countries": ["US", "FR", "DE"],
  "years": [2026, 2027]
}

Add "language": "fr" for localised names, or "types": ["public"] to keep only public holidays.

Working days between dates:

{
  "mode": "businessDaysBetween",
  "countries": ["US", "DE"],
  "ranges": [{ "start": "2026-01-01", "end": "2026-03-31" }]
}

Add working days (negative counts backwards):

{
  "mode": "addBusinessDays",
  "countries": ["US", "GB"],
  "dates": ["2026-12-24"],
  "days": 5
}

SLA deadline in working hours:

{
  "mode": "sla",
  "countries": ["DE"],
  "region": "DE-BY",
  "starts": ["2026-12-23T09:00:00Z"],
  "offset": 8,
  "unit": "hours",
  "dayStart": "08:00",
  "dayEnd": "16:00"
}

Start times need a Z or a numeric UTC offset. The working window defaults to 09:00 to 17:00.

Regional calendars: set region to an ISO 3166-2 code such as US-TX, DE-BY or AU-NSW. It applies to every country in the run, so use one country per run when you want regional data.

Quick start

No code needed; about two minutes from input to spreadsheet. For a longer walkthrough with example output, read the guide Build a holiday calendar and calculate working dates.

1. Open the example "US public holidays 2026 and 2027" on this actor's page, or paste one of the inputs above into the input form.
2. Click Start and wait until the run shows Succeeded.
3. Open the Output tab to see the holidays as a table.
4. Click Export, choose CSV or Excel, and download the file.
5. In Google Sheets, choose File > Import > Upload and select the file.

Automate it

A holiday sheet that stays current: save the countries and years you need in a task. Click Save as a new task, then add a schedule for that task under Schedules in Apify Console (for example every Monday at 07:00). Run it once a month or once a quarter; governments add and move holidays during the year, and each run returns the current calendar.

Into Google Sheets with n8n: add the Apify node with the On new Apify Event trigger, choose your task and the succeeded event, then add an Apify node with Get Dataset Items using the run's defaultDatasetId, and finish with a Google Sheets node that appends the rows. Every scheduled run then adds its holidays to the same sheet. Make and Zapier have Apify integrations that work the same way.

Pricing

$0.002 per row: one holiday, or one calculation. There are no platform usage charges on top. A year of US holidays is about $0.02; holidays for 50 countries for two years is about $2. maxItems (default 10,000) caps a run.

Coverage and data

Holiday data covers more than 200 countries, with regional subdivisions where countries publish them. Data for India, Thailand, Malaysia, Trinidad and Tobago, and the Cayman Islands is marked partial upstream: holidays set by lunar calendars or announced by decree may be missing. Check an official source before relying on those for compliance or contractual deadlines.

Data comes from Nager.Date (MIT) and date-holidays (ISC; holiday definitions CC-BY-3.0), served through the Business Days & Holidays API. The same API is available directly on RapidAPI if you would rather call it from your own code.

FAQ

How do I calculate business days between two dates?

Set mode to businessDaysBetween, give the country and both dates. The row shows total days, business days, weekend days and holidays in between.

How do I add business days to a date?

Use addBusinessDays with a start date and a number of days (negative to count back). Weekends and the country's public holidays are skipped.

Which public holidays 2027 calendars are included?

Every country the data covers, for any year you ask, with regional calendars where countries publish them, such as US states and German Länder.

Questions or a missing holiday? Open an issue on the actor page with the country and date.