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.
Business Days Between Dates:
From Jan 1, 2024 to (but not including) Jan 1, 2025
Days Excluded:
- 52 Saturdays
- 52 Sundays
- New Year's (1/1/2024)
- Martin Luther King Jr. Day (1/15/2024)
- Presidents' Day (2/19/2024)
- Memorial Day (5/27/2024)
- Juneteenth (6/19/2024)
- the Fourth of July (7/4/2024)
- Labor Day (9/2/2024)
- Indigenous Peoples' Day (10/14/2024)
- Veterans Day (11/11/2024)
- Thanksgiving (11/28/2024)
- Christmas (12/25/2024)
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:
- Divide the total number of days by 7 to find how many full weeks are in the period.
- Multiply the number of weeks by 2 to get the total weekend days (assuming a two-day weekend).
- 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:
- Compile a list of official public holidays that fall within your date range (see our list of U.S. holidays below).
- Consider any company-specific holidays that may not be public but are observed within your organization.
- 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]
Federal Holiday | Observed Date |
---|---|
New Year's* | January 2, 2023 |
Martin Luther King Jr. Day | January 16, 2023 |
Presidents' Day | February 20, 2023 |
Memorial Day | May 29, 2023 |
Juneteenth | June 19, 2023 |
the Fourth of July | July 4, 2023 |
Labor Day | September 4, 2023 |
Indigenous Peoples' Day | October 9, 2023 |
Veterans Day* | November 10, 2023 |
Thanksgiving | November 23, 2023 |
Christmas | December 25, 2023 |
Federal Holiday | Observed Date |
---|---|
New Year's | January 1, 2024 |
Martin Luther King Jr. Day | January 15, 2024 |
Presidents' Day | February 19, 2024 |
Memorial Day | May 27, 2024 |
Juneteenth | June 19, 2024 |
the Fourth of July | July 4, 2024 |
Labor Day | September 2, 2024 |
Indigenous Peoples' Day | October 14, 2024 |
Veterans Day | November 11, 2024 |
Thanksgiving | November 28, 2024 |
Christmas | December 25, 2024 |
Federal Holiday | Observed Date |
---|---|
New Year's | January 1, 2025 |
Martin Luther King Jr. Day | January 20, 2025 |
Presidents' Day | February 17, 2025 |
Memorial Day | May 26, 2025 |
Juneteenth | June 19, 2025 |
the Fourth of July | July 4, 2025 |
Labor Day | September 1, 2025 |
Indigenous Peoples' Day | October 13, 2025 |
Veterans Day | November 11, 2025 |
Thanksgiving | November 27, 2025 |
Christmas | December 25, 2025 |
Federal Holiday | Observed Date |
---|---|
New Year's | January 1, 2026 |
Martin Luther King Jr. Day | January 19, 2026 |
Presidents' Day | February 16, 2026 |
Memorial Day | May 25, 2026 |
Juneteenth | June 19, 2026 |
the Fourth of July* | July 3, 2026 |
Labor Day | September 7, 2026 |
Indigenous Peoples' Day | October 12, 2026 |
Veterans Day | November 11, 2026 |
Thanksgiving | November 26, 2026 |
Christmas | December 25, 2026 |
Federal Holiday | Observed Date |
---|---|
New Year's | January 1, 2027 |
Martin Luther King Jr. Day | January 18, 2027 |
Presidents' Day | February 15, 2027 |
Memorial Day | May 31, 2027 |
Juneteenth* | June 18, 2027 |
the Fourth of July* | July 5, 2027 |
Labor Day | September 6, 2027 |
Indigenous Peoples' Day | October 11, 2027 |
Veterans Day | November 11, 2027 |
Thanksgiving | November 25, 2027 |
Christmas* | December 24, 2027 |
Federal Holiday | Observed Date |
---|---|
New Year's* | December 31, 2027 |
Martin Luther King Jr. Day | January 17, 2028 |
Presidents' Day | February 21, 2028 |
Memorial Day | May 29, 2028 |
Juneteenth | June 19, 2028 |
the Fourth of July | July 4, 2028 |
Labor Day | September 4, 2028 |
Indigenous Peoples' Day | October 9, 2028 |
Veterans Day* | November 10, 2028 |
Thanksgiving | November 23, 2028 |
Christmas | December 25, 2028 |
References
- 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