Excel Formulas to Add Days Exclude Certain Days of Week!!
Tags: excelformula, excelformulas
Published: 2021-04-28 06:39:49

---
title: Excel Formulas to Add Days Exclude Certain Days of Week!!
published: true
date: 2021-04-27 05:48:43 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-add-days-exclude-certain-days-of-week/
---

Have you ever tried to calculate the dates excluding the given days? Do you have any good methods for solving this task in Excel? Here we are going to look at **how to add days that exclude certain days of the week in Excel**. Let’s jump into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Add days exclude certain date](https://geekexcel.com/wp-content/uploads/2021/04/Add-days-exclude-certain-date.png)](https://geekexcel.com/excel-formulas-to-add-days-exclude-certain-days-of-week/add-days-exclude-certain-date/#main)<figcaption id="caption-attachment-34805">Add days exclude certain date</figcaption>

## General Formula:

- You can use the below formula to add days to date while excluding specific days (i.e. exclude Tuesdays and Thursdays, Wednesdays only, etc.)

**=[WORKDAY.INTL](https://geekexcel.com/how-to-use-workday-intl-function-in-excel-365/)(date,days,”pattern”)**

## Syntax Explanations:

- **WORKDAY.INTL** – The **[WORKDAY.INTL Function](https://geekexcel.com/how-to-use-workday-intl-function-in-excel-365/)** allows you to customize the weekends(which can any day of the week).
- **Date** – It Represents the input values.
- **Days** – It specifies how many days to be calculated.
- **Pattern** – The pattern code must be 7 digits long and have either a zero for each day of the week. It’s starting on Monday and ending on Sunday.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Refer to the below example image.

- Here, we will enter the input dates in **Column B**.
- Now we will calculate the 7 working days excluding the specified days. It is given as patterns as **Column F**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-31.png)<figcaption id="caption-attachment-34808">Input Ranges</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-23.png)<figcaption id="caption-attachment-34807">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-32.png)<figcaption id="caption-attachment-34806">Result</figcaption>

## Wrap-Up:

Hope you like this article on **how to add days that exclude certain days of the week in Excel**. If you have any **questions** , feel free to **comment**. Thank you so much for visiting our site. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Round up the Value to the Nearest 5s ~ Easy Guide!!](https://geekexcel.com/excel-formulas-to-round-nearest-5s/)**
- **[Excel Formulas to Get Maximum Value from the Given Weekday!!](https://geekexcel.com/excel-formulas-get-maximum-value-from-given-weekday/)**
- **[Use Random Generator to Insert Random Numbers, Dates  Passwords in Excel 365!!](https://geekexcel.com/use-random-generator-to-insert-random-numbers-dates-passwords-in-excel-365/)**