Google Sheets - WORKDAY
WORKDAY function answers questions like this: what date is it after 15 work days from 1/3/2020? Syntax WORKDAY( date, number of work days, [holidays] ) Holidays are optional If number of work days is negative, we calculate like what date it is 3 work days before this date Examples In the above example, it shows that 15 work days after 1/3/2020 is 1/24/2020. However, if we consider holidays, 15 work days after 1/3/2020 is 1/27/2020, because of Martin Luther King Day.