Formula for "Due date = 3 business days before Deploy date?"

Adam M. Forrest

Hi, I would like to build a formula with the following logic: "Due Date = 3 BUSINESS DAYS prior to Deploy Date."

Building a "3 DAYS prior formula is simple enough, but I'm wondering if anyone has solved for logic that can only offer a day that's Monday thru Friday.

I appreciate any advice! -Adam

Shanky Paul

Try the below formula
=WORKDAY([Deploy Date]@row, -3)

[Deploy Date]@row is the cell reference for the Deploy Date.

If you have a list of holidays in another range, you can include them in the formula:
=WORKDAY([Deploy Date]@row, -3, [Holiday Range]:[Holiday Range])

vanstadenster

So glad I found this :) been struggling to write this formula for a few hours!!

As soon as I add Predecessors it seems not to work and loses the formula is there a way around this @Shanky Paul

Adam M. Forrest

That worked beautifully @Shanky Paul ! Thank you so much for your time and assistance, this saved me a lot of effort.