Excel Formulas to Add Workdays to Date with No Weekends!!
Tags: excelformula, excelformulas
Published: 2021-04-29 03:45:59

---
title: Excel Formulas to Add Workdays to Date with No Weekends!!
published: true
date: 2021-04-28 13:05:24 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-add-workdays-to-a-date-with-no-weekends/
---

In modem versions of Excel 2010, 2013 as well as coming Excel 2016, more powerful modifications functions are available, [**WORKDAY.INTL**](https://geekexcel.com/how-to-use-workday-intl-function-in-excel-365/) and **[NETWORKDAYS.INTL](https://geekexcel.com/how-to-use-networkdays-intl-function-in-ms-excel-365/)**, which lets you define how many days are weekends. So here, we will show the simple formulas **to add workdays to date with no weekends in Excel**. Let’s get started!! 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 workdays no weekends](https://geekexcel.com/wp-content/uploads/2021/04/Add-workdays-no-weekends.png)](https://geekexcel.com/excel-formulas-to-add-workdays-to-a-date-with-no-weekends/add-workdays-no-weekends/#main)<figcaption id="caption-attachment-34858">Add workdays no weekends</figcaption>

## General Formula:

- You can use the below formulas to add or subtract workdays days to a date, respecting holidays but assuming a 7-day workweek.

**=[WORKDAY.INTL](https://geekexcel.com/how-to-use-workday-intl-function-in-excel-365/)(start\_date,days,”0000000″, holidays)**

## 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).
- **Start\_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.

## Practical Example:

Refer to the below example image.

- Here, we will enter the input dates in  **Column B**.
- Now we will add the working days to the date with no weekends.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-36.png)<figcaption id="caption-attachment-34860">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-28.png)<figcaption id="caption-attachment-34859">Enter the formula</figcaption>

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

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

## Verdict:

Hope you like this article on  **how to add workdays to date with no weekends 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 Also:

- **[Excel Formulas to Add or Subtract the Month to the Given Date!!](https://geekexcel.com/excel-formulas-to-add-month-to-date/)**
- **[Excel Formulas to Round up the Value to the Nearest 5s ~ Easy Guide!!](https://geekexcel.com/excel-formulas-to-round-nearest-5s/)**
- **[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/)**