Due Dates that exclude weekends and Holidays

Joely Kremer

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)

Brian W

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.