Formulas > =WORKDAY.INTL()
How to Use WORKDAY.INTL() in Google Sheets
Description
How To Actually Use WORKDAY.INTL() in Sheets
WORKDAY.INTL(start_date, num_days, [weekend], [holidays])
Try WORKDAY.INTL yourself
In cell D1, use the WORKDAY.INTL formula to calculate the date that is 10 workdays after the date in cell A1, considering Saturday and Sunday as weekends.
Hints (2)
-
Remember that weekends are represented by a number in the formula.
-
Check the syntax for the number of workdays to add.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the WORKDAY.INTL() formula:
Generate a WORKDAY.INTL() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses WORKDAY.INTL(). 2 free AI generations, no signup. Members get unlimited use.
Generate a WORKDAY.INTL() formula