Docuboxer
By ··Updated ·8 min read

How to count business days (with US holidays)

Count business days or add a deadline with US, Mexico or Spain holidays built in, and see why "day one" and holidays cause most miscounts.

To count business days between two dates, count every calendar day in the span, both endpoints included, and drop Saturdays, Sundays and any holidays that apply. The business days calculator does it for you: pick two dates (or a start date and a number of days to add), choose the United States, Mexico or Spain, and it skips weekends and that country's official holidays, then shows the breakdown so you can check the count. It runs in your browser, so a contract date or a customer deadline is never uploaded anywhere.

How does the business days calculator work?

The tool has two modes:

  • Count business days: choose a start and end date. Both ends are counted by default, and you can untick "Count the start day" or "Count the end day" to match how your deadline is worded.
  • Add a deadline: choose a starting date and a number of business days to add or subtract. The start day itself is not counted, so "5 business days from Monday" lands on the following Monday when no holiday intervenes.

Beside the dates you pick the holiday calendar (United States, Mexico, Spain, or none for weekends only), the weekly days off (Saturday and Sunday, Sunday only, Friday and Saturday, or none), and any extra holidays of your own. The result comes with a breakdown: calendar days, weekend days, holidays that fell on a working day, and the final business-day count, plus the list of holidays inside the period.

Does the count change with holidays? A worked example

Yes, and the difference is easy to see. Take Monday, November 22 to Friday, November 26, 2027, both days counted. That is 5 calendar days, none of them on a weekend. With no holiday calendar the answer is 5 business days. With the United States selected, Thanksgiving on Thursday, November 25 is skipped, so the answer is 4.

Adding days shows the observed-date rule. Independence Day 2027 falls on a Sunday, so the federal holiday is observed on Monday, July 5. Add 3 business days to Thursday, July 1, 2027 with no holidays and you get Tuesday, July 6, 2027. With the US calendar, July 5 is skipped and the result is Wednesday, July 7, 2027. One day of difference is exactly the kind of gap that decides whether a deadline is met.

The ambiguity in "5 business days"

When a vendor says "ships in 5 business days," the question that almost never gets a clear answer is whether today counts as day one, or whether the clock starts tomorrow. Some organizations start the count the moment an order is placed; others start at midnight the following day. Court rules and statutory deadlines usually spell this out explicitly (Federal Rule of Civil Procedure 6, for instance, defines exactly how to count), but everyday business language rarely does. Two people reading the same promise can land on two different dates, both defensible.

The only reliable fix is to get the counting convention stated outright: "starting the next business day" or "including today." If it isn't written down and real money or a real deadline is riding on it, ask rather than assume.

The classic off-by-one: is it 4 days or 5?

This is the most common manual-counting error, and it shows up even when there's no wording ambiguity at all. Between Monday and Friday there are two defensible answers:

  • The difference (subtraction): Friday minus Monday is 4. That's what you get from a raw date subtraction, or from converting both dates to a Unix timestamp and subtracting the raw values.
  • The count of calendar days in the span: Monday, Tuesday, Wednesday, Thursday, Friday, which is 5, counting both ends.

Which one is correct depends on whether the deadline is inclusive. A deadline phrased as "Monday through Friday" is almost always inclusive in practice, so the real answer is 5, but a quick subtraction gives 4 and quietly misses one day. It's the same fencepost problem programmers hit when iterating over a range; here the cost is a missed deadline instead of a bug.

Where this actually matters

This stops being a math curiosity in a few specific, high-stakes situations:

  • Legal and administrative deadlines: filing a response, submitting an appeal, meeting a statutory notice period. Miscounting by a single day can mean missing the window entirely.
  • Support SLAs: "response within 2 business days" means something different for a ticket filed Friday afternoon versus one filed Monday morning.
  • Delivery and shipping estimates: a vendor promising "5 business days" from order date only works if both sides count the same way.
  • PTO and leave accrual: figuring out whether a stretch of time off covers 10 calendar days or 10 business days changes the actual return-to-work date.

Holidays in 2027: Mexico, Spain and the United States

These are the 2027 dates the calculator skips, checked against official sources; for Spain, against the Murcia list. In Mexico and Spain, holidays on a Saturday or Sunday subtract no business day; in the United States they are observed on the Friday or the Monday.

United States: federal holidays

Observed dayHoliday
Friday, January 1New Year's Day
Monday, January 18Martin Luther King Jr. Day
Monday, February 15Washington's Birthday
Monday, May 31Memorial Day
Friday, June 18Juneteenth (June 19 is a Saturday)
Monday, July 5Independence Day (July 4 is a Sunday)
Monday, September 6Labor Day
Monday, October 11Columbus Day
Thursday, November 11Veterans Day
Thursday, November 25Thanksgiving Day
Friday, December 24Christmas Day (December 25 is a Saturday)
Friday, December 31New Year's Day 2028 (January 1, 2028 is a Saturday)

OPM applies the observance rule to most federal employees: a holiday on a Saturday is treated as the Friday before, and one on a Sunday as the Monday after. The December 31 row comes from the OPM's 2028 calendar, which observes January 1, 2028 on that day. State and local holidays are not included.

Mexico: Federal Labor Law, art. 74

DateHoliday
Friday, January 1New Year's Day
Monday, February 1First Monday of February (marks February 5)
Monday, March 15Third Monday of March (marks March 21)
Saturday, May 1Labor Day
Thursday, September 16Independence Day
Monday, November 15Third Monday of November (marks November 20)
Saturday, December 25Christmas Day
Thursday, March 25Holy Thursday (optional in the calculator)
Friday, March 26Good Friday (optional in the calculator)

There is no October 1 in 2027. That day off, reformed by the DOF of September 30, 2024, applies only when the federal Executive changes hands, and the calculator applies it every six years starting in 2024. The law does not move days off that fall on a Saturday, so May 1 and December 25, 2027 subtract no business day. June 6, 2027 is a federal election day (art. 74, section IX), but it falls on a Sunday and does not change the count.

Spain: national holidays

The final official list is still missing. The Dirección General de Trabajo resolution with Spain's 2027 labor holidays was not in the BOE on October 7, 2026; the 2026 one was published on October 28, 2025. The dates below come from the 2027 list published in the BORM of the Region of Murcia on July 27, 2026, except August 15, which comes from article 45 of Royal Decree 2001/1983. Regions can replace some of them, so confirm yours once the BOE resolution appears.

DateHoliday
Friday, January 1New Year's Day
Wednesday, January 6Epiphany (regions can replace it)
Thursday, March 25Holy Thursday (optional in the calculator)
Friday, March 26Good Friday
Saturday, May 1Labor Day
Sunday, August 15Assumption of Mary (falls on a Sunday; the day off moves to Monday, August 16)
Tuesday, October 12National Day of Spain
Monday, November 1All Saints' Day
Monday, December 6Constitution Day
Wednesday, December 8Immaculate Conception
Saturday, December 25Christmas Day

August 15, 2027 is a Sunday. Under article 45.2 of Royal Decree 2001/1983, the day off moves to the following Monday by default: Monday, August 16, 2027 is a day off unless your region replaces it. Article 45.3 lets regions swap that Monday for a holiday of their own, as Murcia does with June 9. The calculator does not subtract August 16: add it by hand, unless your region replaces it.

Which holidays are included, and which are not?

Excluding weekends is mechanical. Excluding holidays is not, because there's no single holiday calendar: it varies by country, and within a country by jurisdiction. That is why the calculator asks which country you mean instead of guessing, and why it is upfront about what each list covers:

  • United States: the federal holidays, with a Saturday holiday observed the Friday before and a Sunday holiday the Monday after. State and local holidays are not included.
  • Mexico: the nationwide mandatory days off only. Election days and state or local closures are not included, and an optional switch adds Holy Thursday and Good Friday for courts and tax offices.
  • Spain: national holidays only. Regional and local holidays change every year, and an optional switch adds Holy Thursday, a holiday in almost every autonomous community.

For anything outside those lists, such as a state holiday, a regional holiday or your company's closure day, type the dates into the Extra holidays box, one per line. That is an honest limitation, not an oversight: no tool outside your jurisdiction can reliably know which days are observed there.

The other tricky one: exact age

Calculating someone's exact age in years, months, and days has its own trap, separate from the business-days problem. Subtracting birth year from the current year isn't enough: you need to check whether this year's birthday has already passed. Someone born November 20th, with today's date in mid-August, still has three months to go before their next birthday, so the calculation has to borrow from the previous year the same way a subtraction borrows across a column, and borrowing correctly means checking how many days the actual previous month has, not assuming a flat 30.

February 29 is the edge case with no clean answer: in a non-leap year, that date simply doesn't exist, so different systems handle a leap-day birthday differently, clamping to February 28 or rolling forward to March 1. Neither is objectively "right"; it's a convention. The date calculator, which handles exact age and calendar differences, clamps to February 28.

What the calculator does, and doesn't do

Worth being direct about this, since it's the only way the tool stays useful. It counts and adds business days, skips the weekends and holidays you configure, and explains its count. It does not replace the official calendar of whoever sets your deadline: for anything with legal weight, the authority is always the actual statute, regulation, or contract, never an online calculator. Use it to sanity-check your own count, not to replace reading the deadline itself. If you also need to move a list of deadline dates into a spreadsheet-friendly format, CSV to JSON conversion handles that without hand-editing rows, and if you're working with Unix timestamps instead of calendar dates, the timestamp converter resolves that other classic ambiguity: seconds versus milliseconds, and which time zone applies.

Related guide: how many days are between two dates, with examples and edge cases.

Sources for the 2027 holidays

For a deadline with legal effect, the date that counts is the one set by whoever issues it. Court, tax office and regional closure days are published separately.

Frequently asked questions

Does "5 business days" include today?

It depends entirely on who wrote the deadline, and that's exactly the problem: there's no universal convention. Some contracts explicitly start counting the following day; others mean today is day one. If a real deadline hinges on it, don't assume. Get it confirmed in writing rather than guessing which reading the other party intended.

Between Monday and Friday, is that 4 days or 5 days?

Both answers are correct for different questions. The difference (a subtraction) is 4. The count of calendar days in the span, both ends included, is 5: Monday, Tuesday, Wednesday, Thursday, Friday. An inclusive deadline uses the second count; a plain date subtraction gives you the first. Mixing them up is the single most common manual-counting mistake.

Are US federal holidays excluded automatically?

In Docuboxer's business days calculator, yes: choose United States and the federal holidays are skipped, including the observed-date rule (a holiday on a Saturday is observed the Friday before, one on a Sunday the Monday after). In a generic spreadsheet formula or a manual count, no. Nothing excludes holidays unless you supply the list.

What about state, regional or company holidays?

They are not built in, because they differ by state, region and employer. Add them yourself in the Extra holidays box, one date per line, either as 2027-12-23 or 12/30/2027. A holiday you add that already falls on a weekend is not subtracted twice.

How do you calculate someone's exact age in years, months, and days?

Subtracting birth year from the current year isn't enough: you have to check whether this year's birthday has already happened. If the reference date falls before the birth month and day, the year count drops by one and the remaining months and days borrow from the actual calendar, not a flat 30-day average. Docuboxer's date calculator does this.

What happens with someone born on February 29?

It's a genuine edge case with no single correct answer. Non-leap years don't have a February 29, so different systems resolve it differently: some clamp the birthday to February 28, others roll it to March 1. Docuboxer's date calculator clamps to February 28, which is the more common convention, but it is a convention, not a law.

Count business days now

Count between two dates or add a deadline, with US, Mexico and Spain holidays. Free and 100% local.

Open business days calculator →

Related tools