Functions
WORKDAY
Date N working days from start date
Try it
When to use it
When should I use WORKDAY instead of NETWORKDAYS?
Use WORKDAY to find a future or past date a number of business days away; use NETWORKDAYS to count business days between two dates.
Use cases
Project a delivery date 10 business days out
Skip a holiday when scheduling a deadline
Used in
operations · hr
Syntax
WORKDAY(start,days,[holidays])Examples
=WORKDAY(DATE(1969,7,20),4) // => 25408
=WORKDAY(40909,10) // => 40921
=WORKDAY(40909,30,{40909,40924}) // => 40952