Date Calculator | Days and Business Days (2024)

Calculator Use

The date calculator adds or subtracts days from a date. Enter a date and the number of days in the future or in the past to calculate your target date.

The default date is today in Coordinated Universal Time UTC. Enter any date and the number of days you need between the two dates. The calculation automatically accounts for leap years.

Business days are the weekdays Monday through Friday. Check Business Days Only to exclude weekend days in your calendar calculation. Check Saturday is a Business Day to include Saturdays.

Holidays are not included in the calculation. Please extend your target date to include the number of holidays in your time span.

Recurring Events

You can use the days calculator to set up a schedule of recurring dates using the Repeat # Days text link. Say you need to replace your A/C filter every 90 days. Enter the date you changed the filter and use the date calculator to add 90 days. There will be a text link "Repeat +90 Days" below the answer. Click on that link to get the next date for your 90 day schedule, repeating as necessary.

When to Use a Date Calculator

A days calculator is helpful when you need to find a date that occurs some number of days ahead of or before today's date. You may need to calculate a date for:

  • Contracts and business agreements
  • Shipping and delivery time frames
  • Planting seeds in a garden
  • Medical procedures and healing time

Example: Shipping and Delivery Time

You placed an online order on October 1 and the company promises delivery within 15 business days. You can expect to receive your order by Oct. 22. Remember, while Oct. 1 plus 15 calendar days is Oct. 16, weekend days are included in that calculation. If you are counting only business days, Oct. 1 plus 15 business days is Oct. 22.

Example: Planting Seeds in a Garden

You have tomato seeds and want to pick mature tomatoes from your garden by August 15. If the seeds take 70 days to germinate, grow and produce tomatoes you need to back-calculate when to plant your seeds. August 15 minus 70 days is June 6. So to have ripe tomatoes by August 15th you need to plant your seeds by June 6th.

Example: Covid-19 Vaccine Booster Shot

You are considering whether to get a Covid-19 vaccination booster shot and want to calculate your eligibility date. Say you are eligible 6 months after your last shot which was July 2. Six months is about 180 days (6 x 30 = 180). Adding 180 calendar days to July 2 puts you at December 29. You are likely eligible to receive a Covid-19 booster shot after this date.

Related Calculator

To find the difference as the number of days between two dates use the Date Difference Calculator. Enter any two dates and the calculator finds how many days are between the two dates. The extra day in leap years is automatically added to the calculation.

Date Formats

Choose the order in which you input the month, day and year of your date.

  • US format is mm/dd/yyyy
  • EU format is dd/mm/yyyy
  • International format is yyyy-mm-dd

Cookies

We use cookies to remember your date format selection preferences.

Holidays

This calculator does not account for holidays. If you are counting holidays as non-business days you must extend your final date to include the number of holidays in the time span.

Federal Holidays from the U.S. Office of Personnel Management.

Financial Market Holidays from NYSE.

Other Ways to Use the Date Calculator

People commonly search for regular periods as in a 180 day calculator, 30 day calculator, 120 day calculator or something like "90 days ago." These common periods of time are generally related to contract deadlines, business payment terms, law and legal deadlines or personal and business contracts.

You can calculate common time frames such as 30 days from a date, 60 days from a date, 90 days from a date, 120 days from a date, 180 days from a date, etc. You can also calculate future business days from a date.

Similarly you can calculate days in the past such as the date 30 days ago, 60 days ago, 90 days ago, 120 days ago, 180 days ago, etc.

Date Calculator | Days and Business Days (2024)

FAQs

What is the formula to add business days to a date? ›

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.

Does 2 business days include today? ›

How Long Is 2 Business Days? Whenever someone says two business days, you can consider the next two consecutive days from that day, excluding the weekends and public holidays. For example, if it's Wednesday today, the next two business days would be Thursday and Friday.

What counts as business days? ›

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.

How do you count business days legally? ›

Count all days, including weekends and Federal holidays. However, if the last day you count is a weekend or Federal holiday, extend or shorten the period (whichever benefits you in complying with the time requirement) to the next regular business day.

What is the formula for dates to days? ›

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.

How to do an Excel formula to calculate 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.

Can Excel calculate business days between two dates? ›

The NETWORKDAYS Function[1] calculates the number of workdays between two dates in Excel. When using the function, the number of weekends are automatically excluded. It also allows you to skip specified holidays and only count business days.

How to do business day in Excel? ›

=WORKDAY(start_date, days, [holidays])

The function uses the following arguments: Start_date (required function) – This is a date that represents the start date. Days (It is a required function) – The number of workdays to be added to start_date.

What is the difference between Networkdays and workdays? ›

The WORKDAY function returns a date N working days in the future or in the past and you can use it to add or subtract workdays to a given date. Using the NETWORKDAYS function, you can calculate the number of workdays between two dates that you specify.

How do you calculate 2 business days? ›

How Long is 2 Full Business Days? When calculating 2 consecutive business days, look at days of the week excluding holidays or weekend days. So, if it's Tuesday, the next two consecutive business days would fall on the upcoming Wednesday and Thursday.

Does 1 business day mean tomorrow? ›

One business day is next day service. FedEx, UPS ground, and express are open Monday to Friday. Saturday is only considered a business day when priority Saturday service is chosen. Otherwise, Saturday is not counted when calculating business days.

Does Saturday count as a business day for banks? ›

Business and Banking Days

Even though a bank may be open for regular business on a Saturday, that day is not considered a banking day for purposes of Regulation CC because Saturday is never a ''business day'' under the regulation.

How do I use only business days 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.

How many business days are 1 day? ›

In Western countries like the U.S., a business day means an 8-hour period of time (or one day) that takes place during the work week. Business days fall between Monday and Friday when normal work hours occur. Business days exclude weekends and public holidays such as Martin Luther King Jr.

How do you count 3 business days? ›

In most cases, three business days means Monday through Friday of the current week, excluding holidays. So, if today is Wednesday, three business days would be Thursday, Friday, and the following Monday.

Can Excel count only business days? ›

The NETWORKDAYS Function[1] calculates the number of workdays between two dates in Excel. When using the function, the number of weekends are automatically excluded. It also allows you to skip specified holidays and only count business days.

References

Top Articles
Homemade Southern Cornbread Dressing Recipe ~Soul Food Style~
Easy Peach Cobbler Recipe - The Cookie Rookie®
Spasa Parish
Rentals for rent in Maastricht
159R Bus Schedule Pdf
Sallisaw Bin Store
Black Adam Showtimes Near Maya Cinemas Delano
Espn Transfer Portal Basketball
Pollen Levels Richmond
11 Best Sites Like The Chive For Funny Pictures and Memes
Finger Lakes 1 Police Beat
Momokun Leaked Controversy - Champion Magazine - Online Magazine
Maine Coon Craigslist
How Nora Fatehi Became A Dancing Sensation In Bollywood 
‘An affront to the memories of British sailors’: the lies that sank Hollywood’s sub thriller U-571
Tyreek Hill admits some regrets but calls for officer who restrained him to be fired | CNN
Haverhill, MA Obituaries | Driscoll Funeral Home and Cremation Service
Rogers Breece Obituaries
Ems Isd Skyward Family Access
Elektrische Arbeit W (Kilowattstunden kWh Strompreis Berechnen Berechnung)
Omni Id Portal Waconia
Kellifans.com
Banned in NYC: Airbnb One Year Later
Four-Legged Friday: Meet Tuscaloosa's Adoptable All-Stars Cub & Pickle
Model Center Jasmin
Ice Dodo Unblocked 76
Is Slatt Offensive
Labcorp Locations Near Me
Storm Prediction Center Convective Outlook
Experience the Convenience of Po Box 790010 St Louis Mo
Fungal Symbiote Terraria
modelo julia - PLAYBOARD
Poker News Views Gossip
Abby's Caribbean Cafe
Joanna Gaines Reveals Who Bought the 'Fixer Upper' Lake House and Her Favorite Features of the Milestone Project
Tri-State Dog Racing Results
Navy Qrs Supervisor Answers
Trade Chart Dave Richard
Lincoln Financial Field Section 110
Free Stuff Craigslist Roanoke Va
Wi Dept Of Regulation & Licensing
Pick N Pull Near Me [Locator Map + Guide + FAQ]
Crystal Westbrooks Nipple
Ice Hockey Dboard
Über 60 Prozent Rabatt auf E-Bikes: Aldi reduziert sämtliche Pedelecs stark im Preis - nur noch für kurze Zeit
Wie blocke ich einen Bot aus Boardman/USA - sellerforum.de
Infinity Pool Showtimes Near Maya Cinemas Bakersfield
Dermpathdiagnostics Com Pay Invoice
How To Use Price Chopper Points At Quiktrip
Maria Butina Bikini
Busted Newspaper Zapata Tx
Latest Posts
Article information

Author: Rueben Jacobs

Last Updated:

Views: 6287

Rating: 4.7 / 5 (57 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Rueben Jacobs

Birthday: 1999-03-14

Address: 951 Caterina Walk, Schambergerside, CA 67667-0896

Phone: +6881806848632

Job: Internal Education Planner

Hobby: Candle making, Cabaret, Poi, Gambling, Rock climbing, Wood carving, Computer programming

Introduction: My name is Rueben Jacobs, I am a cooperative, beautiful, kind, comfortable, glamorous, open, magnificent person who loves writing and wants to share my knowledge and understanding with you.