Business Day Calculator – Find Working Days Between Two Dates

Use our business days calculator to find how many work days there are between two dates. You can also calculate the date in a specified number of work days.

Have a Question or Feedback?

Business Days Between Dates:

From Jan 1, 2024 to (but not including) Jan 1, 2025

251 business days

366 total days - 115 weekend days and holidays

Days Excluded:

Learn how we calculated this below

scroll down


On this page:


How to Calculate Business Days Between Dates

A business day typically refers to any day when normal business operations are conducted. In most countries, this is Monday through Friday, excluding Saturday and Sunday. In many cases, business days also exclude public holidays.

It’s important to note that the definition can vary depending on the company, industry, and region, with some businesses operating on weekends or observing different holidays.

You can calculate the number of business days between dates in a few steps.

Step One: Calculating Basic Difference

The first step is to calculate the total number of days between the two dates without considering weekends or holidays. You can do this using a date range calculator, spreadsheet software, or by manually counting the days on a calendar.

Using a spreadsheet in Google Sheets or Microsoft Excel, you can use the DAYS function, which allows you to calculate the date range in days. To use the function, enter the following formula in an open cell:

DAYS(end_date, start_date)

Step Two: Subtract Weekends

After you count the total number of days, the next step is to calculate the number of weekends within this period. A weekend typically comprises Saturday and Sunday, and you can calculate how many of them are in your date range by doing the following:

  1. Divide the total number of days by 7 to find how many full weeks are in the period.
  2. Multiply the number of weeks by 2 to get the total weekend days (assuming a two-day weekend).
  3. For periods not encompassing a full week, you may need to manually count any remaining weekend days using a calendar.

Step Three: Account for Holidays

Accounting for holidays requires a more customized approach since holidays can vary by country, region, and even within industries or companies. To accurately subtract holidays:

  1. Compile a list of official public holidays that fall within your date range (see our list of U.S. holidays below).
  2. Consider any company-specific holidays that may not be public but are observed within your organization.
  3. Subtract the number of holidays from your total, ensuring not to double-count holidays that fall on weekends unless your calculation method requires adjusting for this.

2024 / 2025 U.S. Federal Holidays

Refer to the table below for the dates for each of the federal holidays as defined in U.S. Code Title 5 § 6103.[1]

Table showing the observed dates for all of the U.S. public holidays in 2023. Holidays denoted with a (*) fall on a Saturday or Sunday and are observed on the Friday before or the following Monday.
Federal HolidayObserved Date
New Year's*January 2, 2023
Martin Luther King Jr. DayJanuary 16, 2023
Presidents' DayFebruary 20, 2023
Memorial DayMay 29, 2023
JuneteenthJune 19, 2023
the Fourth of JulyJuly 4, 2023
Labor DaySeptember 4, 2023
Indigenous Peoples' DayOctober 9, 2023
Veterans Day*November 10, 2023
ThanksgivingNovember 23, 2023
ChristmasDecember 25, 2023
Table showing the observed dates for all of the U.S. public holidays in 2024. Holidays denoted with a (*) fall on a Saturday or Sunday and are observed on the Friday before or the following Monday.
Federal HolidayObserved Date
New Year'sJanuary 1, 2024
Martin Luther King Jr. DayJanuary 15, 2024
Presidents' DayFebruary 19, 2024
Memorial DayMay 27, 2024
JuneteenthJune 19, 2024
the Fourth of JulyJuly 4, 2024
Labor DaySeptember 2, 2024
Indigenous Peoples' DayOctober 14, 2024
Veterans DayNovember 11, 2024
ThanksgivingNovember 28, 2024
ChristmasDecember 25, 2024
Table showing the observed dates for all of the U.S. public holidays in 2025. Holidays denoted with a (*) fall on a Saturday or Sunday and are observed on the Friday before or the following Monday.
Federal HolidayObserved Date
New Year'sJanuary 1, 2025
Martin Luther King Jr. DayJanuary 20, 2025
Presidents' DayFebruary 17, 2025
Memorial DayMay 26, 2025
JuneteenthJune 19, 2025
the Fourth of JulyJuly 4, 2025
Labor DaySeptember 1, 2025
Indigenous Peoples' DayOctober 13, 2025
Veterans DayNovember 11, 2025
ThanksgivingNovember 27, 2025
ChristmasDecember 25, 2025
Table showing the observed dates for all of the U.S. public holidays in 2026. Holidays denoted with a (*) fall on a Saturday or Sunday and are observed on the Friday before or the following Monday.
Federal HolidayObserved Date
New Year'sJanuary 1, 2026
Martin Luther King Jr. DayJanuary 19, 2026
Presidents' DayFebruary 16, 2026
Memorial DayMay 25, 2026
JuneteenthJune 19, 2026
the Fourth of July*July 3, 2026
Labor DaySeptember 7, 2026
Indigenous Peoples' DayOctober 12, 2026
Veterans DayNovember 11, 2026
ThanksgivingNovember 26, 2026
ChristmasDecember 25, 2026
Table showing the observed dates for all of the U.S. public holidays in 2027. Holidays denoted with a (*) fall on a Saturday or Sunday and are observed on the Friday before or the following Monday.
Federal HolidayObserved Date
New Year'sJanuary 1, 2027
Martin Luther King Jr. DayJanuary 18, 2027
Presidents' DayFebruary 15, 2027
Memorial DayMay 31, 2027
Juneteenth*June 18, 2027
the Fourth of July*July 5, 2027
Labor DaySeptember 6, 2027
Indigenous Peoples' DayOctober 11, 2027
Veterans DayNovember 11, 2027
ThanksgivingNovember 25, 2027
Christmas*December 24, 2027
Table showing the observed dates for all of the U.S. public holidays in 2028. Holidays denoted with a (*) fall on a Saturday or Sunday and are observed on the Friday before or the following Monday.
Federal HolidayObserved Date
New Year's*December 31, 2027
Martin Luther King Jr. DayJanuary 17, 2028
Presidents' DayFebruary 21, 2028
Memorial DayMay 29, 2028
JuneteenthJune 19, 2028
the Fourth of JulyJuly 4, 2028
Labor DaySeptember 4, 2028
Indigenous Peoples' DayOctober 9, 2028
Veterans Day*November 10, 2028
ThanksgivingNovember 23, 2028
ChristmasDecember 25, 2028

References

  1. U.S. Federal Government, Title 5 - Government Organization and Employees § 6103. Holidays, https://www.govinfo.gov/content/pkg/USCODE-2022-title5/pdf/USCODE-2022-title5-partIII-subpartE-chap61-subchapI-sec6103.pdf