Due Dates that exclude weekends and Holidays

Joely Kremer · 01/18/19

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 · 01/18/19

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.

Screen Shot 2019-01-18 at 4.25.52 PM.png

Detrie Zacharias · 09/19/19

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

SLA - Two columns. Task Type and Days
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

Andrée Starå · 10/28/19

Hi Stavros,

Did you get it working or do you still need help?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Due Dates that exclude weekends and Holidays

Comments

Categories