How to add days to date including or excluding weekends and holidays in Excel

When you add days to a given date, you are excluding weekends and holidays, which means that you are adding business days from Monday to Friday, not weekends and holidays.

Adding Business days Excluding Weekends with the formula

Kindly find the below steps to add days excluding weekends.

Step 1

Open an Excel workbook, add date and days to it as you desire and enter the below formula in the blank cell and then press Enter key to get the output or result.

 =WORKDAY(A2,B2) 

In this A2 cell is the start date and the B2 cell is the days that you have mentioned.

Step 2

Now the End date with 35 business days excluding the weekends is added to the Excel workbook in cell C2.

Step 3

If you see a result date in five digit number, you can format it to the date by using the below method.

Click on Home and then Number Format and then select a short date. It will format to the actual date.

Add Business Days Excluding Weekends and Holidays with the Formula.

If you have a range of cells that contain numerous holidays, for example, and you want to add days to a given date that do not include weekends and these holidays, then you need to do the following.

Step 1

Open an Excel workbook and mention the desired dates to it. For example, enter a date in the cell A9 and days in cell A10. Consider the holidays and enter those dates in the cell B12, B13 and B14.

Step 2

Enter the below mentioned formula in the blank cell of the Excel workbook and press Enter Key to get the result and mentioned it as End date.

 =WORKDAY(A9,B9,B12:B14) 

Holiday dates are the date which you have entered to exclude them.

This is how you will add days to date including or excluding weekends or holidays in an Excel workbook.