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

Can you calculate working days between two dates? ›

To calculate the number of working days between two dates, we must follow these steps: Count the number of days between the two dates. Subtract the number of weekend days between the two dates.

How many days are 25 business days? ›

By default, they are talking about a five week period (five business days out of each week, so 25 / 5 = 5.

How do you determine the 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.

How to count workdays between two dates in Excel? ›

Use the NETWORKDAYS.INTL function when you want to calculate the number of workdays between two dates. You can also have it exclude weekends and holidays too.

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.

Can you calculate days between two dates in Excel? ›

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.

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

You would need to type =DATEDIF( into the required cells. In the below table, we seek to calculate the number of days between two sets of dates.

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

Time Difference in Excel
  1. Enter the start date and time in cell A2 and hit Enter. ...
  2. Enter the end time in cell B2 and hit Enter.
  3. Enter the formula =B2-A2 in cell C2 and hit Enter. ...
  4. Right-click on C2 and select Format Cells. ...
  5. Choose the Custom category and type “h:mm”
Apr 12, 2023

How many days are one or two business days? ›

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 many days are 2 business days from Friday? ›

So, if it's Tuesday, the next two consecutive business days would fall on the upcoming Wednesday and Thursday. However, if it's Friday, the next two consecutive business days would fall on the following Monday and Tuesday since there is a weekend in between.

How many days are 7 business days? ›

"7 business days" means the action or process should take approximately one week, considering only the business days (Monday through Friday) and excluding weekends. "10 business days" means the action or process should take approximately two weeks, considering only business days and excluding weekends.

How to 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 difference between calendar 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.

What day is count 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.

Can Excel calculate days between two dates? ›

Calculate the difference in days

Select cell D2, which is the first blank cell in the Duration column. Type =C2-B2, and then press RETURN . Excel displays the result as the number of days between the two dates (104). Select cell D2.

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

Syntax: =DATEDIF(start date, end date, “D”) where “D” signifies days. NETWORKDAYS function: Calculates working days, excluding weekends and optionally holidays. Syntax: =NETWORKDAYS(start date, end date, [holidays]).

How do I calculate work weeks between two dates in Excel? ›

Calculate Weeks Between Dates in Excel

For weeks, divide the number of days by 7. The formula is as follows: =DATEDIF(start_date, end_date, "d")/7. Replace start_date and end_date with your specific dates.

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

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

References

Top Articles
Latest Posts
Article information

Author: Amb. Frankie Simonis

Last Updated:

Views: 6436

Rating: 4.6 / 5 (76 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Amb. Frankie Simonis

Birthday: 1998-02-19

Address: 64841 Delmar Isle, North Wiley, OR 74073

Phone: +17844167847676

Job: Forward IT Agent

Hobby: LARPing, Kitesurfing, Sewing, Digital arts, Sand art, Gardening, Dance

Introduction: My name is Amb. Frankie Simonis, I am a hilarious, enchanting, energetic, cooperative, innocent, cute, joyous person who loves writing and wants to share my knowledge and understanding with you.