Excel Formulas to Add Workdays to Date with Custom Weekends!!
Tags: excelformula, excelformulas
Published: 2021-04-29 03:46:23

---
title: Excel Formulas to Add Workdays to Date with Custom Weekends!!
published: true
date: 2021-04-28 13:35:19 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-add-workdays-to-date-with-custom-weekends/
---

In the previous post, we have learned **[how to add weekdays to date with no weekends](https://geekexcel.com/excel-formulas-to-add-workdays-to-a-date-with-no-weekends/)**. Similarly, here, we will show the simple formulas **to add workdays to date with Custom Weekends in Excel**. Let’s get 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 workdays with custom weekends](https://geekexcel.com/wp-content/uploads/2021/04/Add-workdays-with-custom-weekends.png)](https://geekexcel.com/excel-formulas-to-add-workdays-to-date-with-custom-weekends/add-workdays-with-custom-weekends/#main)<figcaption id="caption-attachment-34872">Add workdays with custom weekends</figcaption>

## General Formula:

- If you want to add or subtract workdays to a date with custom weekends, you can use the below formula.

**=[WORKDAY.INTL](https://geekexcel.com/how-to-use-workday-intl-function-in-excel-365/)(start\_date,days,weekend, 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.
- **Weekend** – It represents the custom weekends.
- **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.

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

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

- In the given formula, we will give the **weekend as 11** , which means **“Sunday”** only.
- Finally, we will get the result in the selected cell.

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

## Verdict:

From this article, we have described **how to add workdays to date with custom weekends in Excel**. Leave a **comment** or **reply** below let me know what you think! 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/)**