Add the Business Days to Date

You might have come across a situation where you need to add (or subtract) the specified business days to a particular date. There is also a possibility that you might have completed this kind of task manually. Still, it seems possible if you have to add or subtract specified days to a few dates, but when it comes to a lot of dates, then doing such tasks manually would be a foolish attempt because doing this task manually would not only exhaust you but also waste a lot of time, and as a result, your work would not complete on the specified time.

But don’t worry, since after attentively reading this post, you will learn the simplest way to add business days to a list of dates in a matter of seconds.

So without any delay, let’s get into it;

_4 Add business days to date1

General Formula

In MS Excel, if you want to add days into a given date in just a matter of seconds, then  the following formula would help you out:

=WORKDAY(start date,adding_days,holidays)

Explanation of Syntax:

Before getting to know the usage of this formula for getting the work done in an efficient way, we first need to understand each syntax so that you can understand how each syntax helps to add days into a given date in just a matter of seconds :

  • WORKDAY: The WORKDAY function in MS Excel is used to compute the closest working day based on a value. Business days or workdays are any days other than Saturday and Sunday.
  • Start date: This parameter provides the input dates.
  • Holidays: This column indicates the additional holidays listed in the spreadsheet, so this formula reads this formula to decide if there is any holiday on those days.
  • Comma Symbol (,): This symbol is like a separator that aids in the separation of a list of values.
  • Parenthesis (): This primary function of this symbol is to group the elements.

Explanation:

 The formula WORKDAY function can subtract or add business days (workdays) from a date to generate a date in the past or future(respectively) that skips weekends (and holidays). Vacations are optional.

The formula in F2 in the example is:

=WORKDAY(A2,10,A12:A13)

_4 Add business days to date1

The above formula would add 10 days to dates in column A, and returns the results on column F.

Weekends are excluded by default from the WORKDAY function (Saturday and Sunday). In this example, we’ve also included a list of three holidays that occur within the date period being computed, implying that both weekends and holidays are eliminated.

Subtract Business from a Date

You can provide a negative number for days to subtract business from a date (rather than adding workdays).

For example, to obtain a date five workdays before a date in A2, use:

 =WORKDAY(A2,-5)

_4 Add business days to date1

If you find the above example challenging to grasp, don’t worry since another example below will walk you through the procedure step by step:

 Take a look at the example image below.

  1.  To begin, insert the input dates in Column A.
  2. We’ll now compute the 10 working days minus the additional holiday specified in range .
  3.  Enter the formula mentioned earlier into the formula bar section and press the ENTER:
 =WORKDAY(A2,10,A12:A13)

_4 Add business days to date1

4. Finally, the result will be shown in the selected cell.

 You can ignore the holidays range from the algorithm if you wish to compute the days without the supplied holidays. Please see the image below.

=WORKDAY(A2,10)

_4 Add business days to date1

Conclusion

 This blog post efficiently explains how you can use the basic Excel formula to add business days to a date that excludes weekends and holidays. I hope you understood it completely.

Related Functions

  • Excel WORKDAY function
    The Excel WORKDAY function returns a serial number that represents a date that is the indicated number of working days before or after the starting date you specified.The syntax of the WORKDAY function is as below:=WORKDAY(start_date, days, [holidays])…
Related Posts

Sort/Rank Numeric Values with Duplicate Values Exist

Excel built-in RANK function can sort a set of values. If there are duplicate numbers, then the rank number is also duplicated. See the following example: There are two numbers “100” in range A2:A9, they are both the third largest ...

Calculate Days Open in Excel

If you want to know how to Calculate days in Excel, there are some formulas that you can use to do so. For example, you can use the DAYS function in Excel to find the number of days between two ...

Calculate Grades With VLookup in Excel

Why Should You Calculate Grades With VLookup Excel? If you're looking for a simple way to find out a student's grades, VLOOKUP Excel can do the trick. This function uses a lookup table to find the values and sort them ...

Repeating Character n Times in Excel
Repeating Character n Times in Excel1

In daily life, we can use repeated characters to indicate the magnitude or priority of something. For example, a single “!” indicates a minor case, double “!!” indicates a medium case, and triple “!!!” indicates a high case, and so ...

Calculate Cumulative Loan Interest in Excel
calculate cumulative loan interest excel1

What is Cumulative Loan Interest? When comparing different types of loans, many people want to know what is Cumulative Loan Interest. The sum of all interest payments you've made on a loan is referred to as cumulative interest. Different lenders ...

Calculate Cumulative Loan Principal Payments in Excel
Calculate Compound loan principal payments excel1

How do you Calculate Cumulative Loan Principal Payments in Excel? There are a few different ways to calculate this information, but one way has been proven to be accurate more often than others. One option is to use the CUMPRINC ...

Trap Error or Replace Error by Specific Value with IFERROR function
Trap Error or Replace Error by Specific Value with IFERROR function1

We often use Excel formulas in our work life, and we may encounter this situation that the formula throws an error and finally an error like #DIV/0! Is displayed in the cell. In today’s tutorial, we will introduce you the ...

Calculate Compound Interest in Excel

This article will show you how to calculate compound interest in Excel. It will help you calculate the interest you will accrue on a given amount of money. There are several ways to calculate compound interest. One of the simplest ...

Count Attendance and Absence with COUNTIF function
Count Attendance and Absence1

In our campus life and work life, we usually record everyone's attendance. Today we will introduce you the application of Excel COUNTIF function to count the attendance. Using a week as an example, we use the following example to show ...

Find the Closest Data to the Data Provided in Excel

In our daily work, we may encounter such an issue that to find the closest value to a certain value. In fact, Excel internal functions can help us solve this problem. In today’s article, we will show you how to ...

Sidebar