3

I need a formula that will return a date that does not include weekends or holidays. 

For example:

Notification Date 1/18/19

Due Date (formula that counts 20 business days from the notification date and excludes holidays). It should return 2/16/19 because MLK day is on Monday)

Comments

You can use:

=WORKDAY([Notification Date]@row, 20, Holidays:Holidays)

But you have to create a Holiday column and manually fill it with holidays.

In this case it is returning 2/18 because 2/16 is a Saturday.

This is great thanks for posting.

I need to take it a step further but I cant figure out the syntax

I have two supporting sheets to manage SLAs and Holidays

  1. SLA -  Two columns. Task Type and Days
  2.  Holidays - Two Columns. Name and Date

Created is a timestamp

I need to populate Due Date with this logic

Due Date = Created (date only) + SLA (days column) account for workday and holiday (date column)

This is the only part I can get to work so far

=DATEONLY(Created1) + SLA1