In the previous post, we have learned how to add weekdays to 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
General Formula:
- If you want to add or subtract workdays to a date with custom weekends, you can use the below formula.
=WORKDAY.INTL(start_date,days,weekend, holidays)
Syntax Explanations:
- WORKDAY.INTL – The WORKDAY.INTL Function 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.
- So, apply the above-given formula to the formula bar section and press the ENTER key.
- 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.
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 **and Excel Formulas *!! **
Top comments (0)