Business Day Calculator - Find Working Days Between Two Dates (2024)

Table of Contents
Have a Question or Feedback? Business Days Between Dates: From Jan 1, 2024 to (but not including) Jan 1, 2025 On this page: Cite As: How to Calculate Business Days Between Dates Step One: Calculating Basic Difference Step Two: Subtract Weekends Step Three: Account for Holidays 2024 / 2025 U.S. Federal Holidays FAQs

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:

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:

  • 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)
See Also
Date Calculator | Days and Business DaysExcel DATE function with formula examples to calculate datesTI Products | Calculators and Technology | Texas InstrumentsCOVID-19 and Your Health

Result Date:

Learn how we calculated this below

Chevron Down Icon scroll down

Add this calculator to your site

On this page:

  • Business Day Calculator
  • How to Calculate Business Days Between Dates
  • Step One: Calculating Basic Difference
  • Step Two: Subtract Weekends
  • Step Three: Account for Holidays

By

Business Day Calculator - Find Working Days Between Two Dates (1)

Joe is the creator of Inch Calculator and has over 20 years of experience in engineering and construction. He holds several degrees and certifications.

Full bioChevron Right Icon

See Also
Brexit: What you need to know about the UK leaving the EU

Cite As:

Sexton, J. (n.d.). Business Day Calculator – Find Working Days Between Two Dates. Inch Calculator. Retrieved June 7, 2024, from https://www.inchcalculator.com/business-day-calculator/

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
Business Day Calculator - Find Working Days Between Two Dates (2024)

FAQs

How do I count workdays between two dates in Excel? ›

=NETWORKDAYS(start_date, end_date, [holidays])

The function uses the following arguments: Start_date (required argument) – Start_date can either be earlier than end_date, later than end_date, or same as end_date. End_date (required argument) – The end date.

Read On ›
Is there a way to calculate the number of days between two dates? ›

To calculate the number of days between two dates, you need to subtract the start date from the end date.

Learn More Now ›
How do you calculate one business day? ›

A business day refers to any day in which normal business operations are conducted. In Western countries, a business day lasts eight hours and is considered to be Monday through Friday from 9 a.m. to 5 p.m. local time. Business days do not include weekends and public holidays.

Find Out More ›
How to use Excel to calculate how many days between two dates? ›

To find the number of days between these two dates, you can enter “=B2-B1” (without the quotes into cell B3). Once you hit enter, Excel will automatically calculate the number of days between the two dates entered. Note that Excel recognizes leap years.

Discover More ›
How do I calculate working days between two dates in Google Sheets? ›

How do you use the WORKDAY function in Google Sheets?
  • Type “=WORKDAY(” or go to “Insert” → “Function” (or directly navigate to the “Functions” icon) → “Date” → “WORKDAY”.
  • Input the starting date, the number of working days to add, and dates of holidays to be excluded from the specific period.
  • Press the “Enter” key.

Explore More ›
What is the formula for workday? ›

Open Excel and select the cell where you would like the result to be displayed. Enter the formula “=WORKDAY(start_date, num_days)” in the selected cell. Replace “start_date” with the desired starting date and “num_days” with the number of days to add or subtract. Press Enter to calculate the result.

Learn More ›
What is the difference between Networkdays and workdays? ›

Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

Tell Me More ›
How to calculate days and hours between two dates and times in Excel? ›

Another simple technique to calculate the duration between two times in Excel is using the TEXT function:
  1. Calculate hours between two times: =TEXT(B2-A2, "h")
  2. Return hours and minutes between 2 times: =TEXT(B2-A2, "h:mm")
  3. Return hours, minutes and seconds between 2 times: =TEXT(B2-A2, "h:mm:ss")
Mar 21, 2023

Read The Full Story ›
Which formula can be used to find the days between two dates? ›

The DAYS function in Excel is a formula designed to compute the count of days between two given dates. The syntax for the function is “=DAYS(end_date, start_date).” Therefore, the end date is specified as the first argument in the formula, and the start date is specified as the second argument in the formula.

Show Me More ›
What is the formula for the number of dates between two dates? ›

e.g., start date in cell A1 and end date in cell B1, use the formula =B1 - A1.

See More ›

What is the formula for Datedif in Excel? ›

In Column C, you can write out the following specific formula: =DATEDIF(A3,B3"Y"). Click the "Enter" button using your mouse or trackpad, and the number difference between Column A and Column B's dates in years appears.

See More ›
How many working days between two dates in Excel? ›

The NETWORKDAYS function in Excel returns the number of workdays between two dates, excluding weekends and, optionally, the holidays you specify. The first two arguments are obligatory and the third one is optional: Start_date - initial date from which to start counting working days.

Get More Info ›
How do I calculate only business days in Excel? ›

Then, to calculate the number of business days in the specified time period, type the formula =NETWORKDAYS(B3,B4), where B3 is the starting date and B4 is the ending date.

Read The Full Story ›
What is the difference between working days and business days? ›

Working days are the days of the week when most people are expected to work. Business days, on the other hand, are the days of the week when most businesses are open and conducting transactions. Business days may include weekends, depending on the specific industry or company.

Tell Me More ›
What is the formula for date working days? ›

Enter the formula “=WORKDAY(start_date, num_days)” in the selected cell. Replace “start_date” with the desired starting date and “num_days” with the number of days to add or subtract. Press Enter to calculate the result.

Show Me More ›
What is the formula for Networkdays excluding weekends and holidays? ›

The Excel NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates. For example, in the screenshot shown, the formula in D6 is: =NETWORKDAYS(B6,C6...

Read The Full Story ›
What is the difference between networkdays and workdays in Excel? ›

Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

Read On ›
Top Articles
Julian Assange: cuáles son los secretos que reveló por los que estuvo 7 años asilado y 5 detenido - BBC News Mundo
Les dix plus grosses révélations de Wikileaks
How to Authorize Release of your Financial Aid Record to a Third Party or Obtain a Record of your Financial Aid Information
Brooklyn College Tuition and Financial Aid
Plenarvortrag. Plenarvortrag. Plenarvortrag - KIPDF.COM
Die N-Deklination (mit Beispielen) - Deutsch-Coach.com
Healthstream Acadia Login
Industry Standard w/ Barry Katz - Winamp
Latest Posts
Julian Assange : pourquoi j’ai fondé WikiLeaks
Step by step guide to fill e-Operasi form
Article information

Author: Kelle Weber

Last Updated:

Views: 5331

Rating: 4.2 / 5 (53 voted)

Reviews: 84% of readers found this page helpful

Author information

Name: Kelle Weber

Birthday: 2000-08-05

Address: 6796 Juan Square, Markfort, MN 58988

Phone: +8215934114615

Job: Hospitality Director

Hobby: tabletop games, Foreign language learning, Leather crafting, Horseback riding, Swimming, Knapping, Handball

Introduction: My name is Kelle Weber, I am a magnificent, enchanting, fair, joyous, light, determined, joyous person who loves writing and wants to share my knowledge and understanding with you.