Time Formula

Ken Hoffman

Hi @ericncarr, No not yet. It has been a crazy few weeks.

ericncarr

@Ken Hoffman ,

I'd just change the formula to use NETWORKDAYS, I think you want to add the -1 so it doesn't count the existing day but I haven't looked at this in a while so you'd want to play with it.

=IF(NETWORKDAYS([CD Date]@row, [RD Date]@row) - 1 < 2, "Yes", IF(AND(NETWORKDAYS([CD Date]@row, [RD Date]@row) - 1, [CD 24hr Dec]@row <= [RD 24hr Dec]@row), "Yes", "No"))

Ken Hoffman

Hi@ericncarr,

I tried updating and playing with it but the column would now update to always met sla. I added you to my sheet to see if I am missing something.