Calculating Next Working Day

[reberryjr]

I have several different categories of work in a spreadsheet, where not all categories have the same SLA for completion. I've been using this formula for the past few months, and there hasn't been an issue, until last Friday. Essentially, a record came in with a start date of 11/22/18. That record has a SLA of 1 day. Because 11/22/18 was a holiday, the SLA date should have been returned as 11/23/18. Instead, this formula is returning the date of 11/24/18, which is a Saturday. I always understood that the Workday function automatically excluded Saturday and Sunday.

Thoughts on where I went wrong?

=WORKDAY(D2,1+(WEEKDAY(D2,1)>6),Variables!D$2:D$11)+COUNTIF(Variables!D$2:D$11,D2)

 

[steve the fish]

You may be better nesting a workday formula:

=WORKDAY(WORKDAY(D2-1,1,Variables!$D$2:$D$11),1,Variables!$D$2:$D$11)

 

[reberryjr]

No Sir. If the SLA date lands on a weekend, it should push to the next working day, that is also not a holiday.

 

[steve the fish]

No Sir. If the SLA date lands on a weekend, it should push to the next working day, that is also not a holiday.

Thats what it does. It is impossible for the workday formula to give a date that is on a weekend. Its sole aim is to produce a working day.