How to add number of days excluding weekends and holidays to a certain date in Excel?

In this article, we'll explore how to add business days to a date in Excel, excluding weekends and holidays. This method ensures that only weekdays (Monday to Friday) are counted when adding days, making it ideal for tasks like project scheduling or calculating deadlines that depend on business days.

Add business days excluding weekends with formula

Add business days excluding weekends and holidays with formula

Add days including weekends and holidays with Kutools for Excel 

Count weekends or weekdays only between two given dates with Kutools for Excel

 Add business days excluding weekends with formula

To add days excluding weekends, you can do as below:

Select a blank cell and type the following formula and press "Enter" key to get result.

=WORKDAY(A2,B2)

Tip: In the formula, A2 is the start date, B2 is the days you want to add.

Now, the end date, which adds 45 business days excluding weekends, is shown.

Note: If the calculated result is a 5-digit number, you can format it to date with clicking" Home" >" Number Format" >" Short Date". See screenshot:

 Add business days excluding weekends and holidays with formula

If you have a range of cells containing the holidays, and now you want to add days excluding weekends and these holidays to a given date, how can you handle it?

Select a blank cell and type the following formula then press "Enter" key to get the result.

=WORKDAY(A2,B2,B4:B6)

Tip: In the formula, A2 is the start date, B2 is the days you want to add, and B4:B6 is the holidays you want to exclude.

 Add days including weekends and holidays with Kutools for Excel

If you want to add days including weekends and holidays, you can use "Kutools for Excel"’s "Date & Time helper" function.

1. Select a cell which place the adding result, click "Kutools" > "Formula Helper" > "Date & Time helper".

2. In the "Date & Time Helper" dialog, check "Add" option (if you want to subtract days, please check "Subtract" option), then click the range selection button to select a date cell you use, or you can click the calenda icon to select a date from the calendar, and then type the number of days or years or months, weeks into the textboxes in" Enter numbers of select cells which contain values you want to add" section.

3. Click "OK". Then the result has been calculated, you can drag fill handle over cells which need this formula.

With this helper, you can add x year, y month and z days together at once to a date.

 Count weekends or weekdays only between two given dates with Kutools for Excel

With "Kutools for Excel" installed, you can count the number of weekends or weekdays only between two given dates.

1. Select a blank cell which you will place the counting result into, and click "Kutools" > "Formula Helper "> "Formula Helper".

2. Then in the poppsing "Formula Helper" dialog, choose "Statistical" from "Formula Type" drop-down list, then click at "Number of working days between two dates" in "Choose a formula" section, then go to right part, click the range selection button to select the start date and end date cells.

3. Click "Ok", and only the weekdays between two given dates have been counted out.

---

Unbelievable! A tool changes the way on editing and browsing multiple Office documents.

Free Download Office Tab

Open files in multiple windows		Open files in one tabbed window with Office Tab

Related Articles:

• How to count unique/duplicate dates in an Excel column?
• How to quickly split date into separate day, month and year in Excel?
• How to add/subtract weeks to date in Excel?
• How to split date and time from a cell to two separated cells in Excel?