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? ›

=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.

How do you calculate business days? ›

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.

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.

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.

How do I convert calendar days to business days? ›

So n calendar days should be approximately n*4/7 working days. This formula is pretty good for many purposes with large numbers, and will only be off by a few days at most.

Is there a formula in Excel to count 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.

How do you add 2 business days in Excel? ›

Select a blank cell and type this formula =WORKDAY(A2,B2), and press Enter key to get result. Tip: In the formula, A2 is the start date, B2 is the days you want to add.

What is the difference between days and business days? ›

Calendar days refer to every day on the calendar, i.e. all 365 days of the year (366 if it is a leap year). Working days or business days means any day other than a Saturday, Sunday or public holiday.

Do business days include Saturday? ›

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.

Does 10 days mean business days or calendar days? ›

10 days means 10 total calendar days. If the 10th day falls on a weekend or holiday then it would extend to the next business day.

Does 1 business day mean tomorrow? ›

Hello, 1 business day means within 24 hours. So it may be there in the morning or it may not be there.

Does 4 business days include the current day? ›

For example, four business days in one week would be Monday thru Thursday or Tuesday thru Friday. Basically, it is four days not counting weekends or holidays. 4 working days, excluding Bank Holidays and weekends. It could be monday to thursday inclusive, tuesday to Friday, Wednesday to the following monday…

Is a business day one 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 find the exact time between two dates? ›

To calculate the number of days between two dates, you need to subtract the start date from the end date.
  1. If this crosses several years, you should calculate the number of full years.
  2. For the period left over, work out the number of months.
  3. For the leftover period, work out the number of days.
Jan 18, 2024

What is the formula for the difference between two dates? ›

If we want to calculate the difference between two dates in years, months, and days together, then we have to use the following formula: =DATEDIF(A2, B2, "y") &" years, "&DATEDIF(A2, B2, "ym") &" months, " &DATEDIF(A2, B2, "md") &" days"

How to calculate time difference in Excel between two dates? ›

A: To calculate the time difference in Excel between two dates, you can use the DATEDIF function. To apply it, enter the start and end date in two separate cells and execute the formula =DATEDIF(Start_date,End_date,”unit”).

References

Top Articles
Exciting Gender Reveal Ideas for 2024
20 Unique and Trending Gender Reveal Ideas for 2023
Swissport Timecard
Mansfield Shower Surround
Canvas Rjuhsd
Craigslist Centre Alabama
Lvc Final Exam Schedule
Tmobile Ipad 10Th Gen
Q-global Web-based Administration, Scoring, and Reporting
Selinas Gold Full Movie Netflix
Msu Ro
An Honest Review of Accor Live Limitless (ALL) Loyalty Program
Scrotal Support Walgreens
Watch Valimai (2022) Full HD Tamil Movie Online on ZEE5
Craigslist Sfbay
Ups Customer Center Locations
24 Hour Pharmacy St Louis Mo
Battlenet We Couldn't Verify Your Account With That Information
Ice Dodo Unblocked 76
Gsa Elibary
Vegamovies Marathi
Ekaterina Lisina Wiki
Weer Maasbracht - Vandaag - Morgen - 14 dagen
Busted Paper Haysi Regional Jail
Osrs Toby
Mgmresorts.okta.com Login Page
Vip Market Vetsource
Walgreens On Nacogdoches And O'connor
Hartford Healthcare Employee Tools
Road Conditions Riverton Wy
Refinery29 Horoscopes
Phun.celeb
Wayne Carini How Tall
Planet Zoo Obstructed
Most Popular Pub food in Lipetsk, Lipetsk Oblast, Russia
Rs3 Bring Leela To The Tomb
Phoenix | Arizona, Population, Map, & Points of Interest
2010 Ford F-350 Super Duty XLT for sale - Wadena, MN - craigslist
5Gomovies
Optum Director Salary
How Do I Change My Usaa Pin
Directions To 401 East Chestnut Street Louisville Kentucky
Baywatch 2017 123Movies
Mathews Vertix Mod Chart
2022 Basketball 247
Yoshidakins
Rainfall Map Oklahoma
University Of Oregon Id
Kaiju Universe: Best Monster Tier List (January 2024) - Item Level Gaming
Katia Uriarte Husband
Walb Game Forecast
Navy Qrs Supervisor Answers
Latest Posts
Article information

Author: Aron Pacocha

Last Updated:

Views: 5669

Rating: 4.8 / 5 (68 voted)

Reviews: 91% of readers found this page helpful

Author information

Name: Aron Pacocha

Birthday: 1999-08-12

Address: 3808 Moen Corner, Gorczanyport, FL 67364-2074

Phone: +393457723392

Job: Retail Consultant

Hobby: Jewelry making, Cooking, Gaming, Reading, Juggling, Cabaret, Origami

Introduction: My name is Aron Pacocha, I am a happy, tasty, innocent, proud, talented, courageous, magnificent person who loves writing and wants to share my knowledge and understanding with you.