Forum Discussion
Solved
Varying Holiday Observation Date based on DOW of another holiday formula help.
Hello, The attached spreadsheet has a Holiday tab on it and i'm trying to figure out the formula needed to make it work, to where as the new contract completion date on Roadway Zone 3 tab can not...
drt_80 , perhaps
=E13+CHOOSE(WEEKDAY(E13,2),1,-1,-1,1,-1,-2,2)
drt_80 , perhaps
=E13+CHOOSE(WEEKDAY(E13,2),1,-1,-1,1,-1,-2,2)
That was it!! Thank you so much. You all are GREAT!SergeiBaklan
drt_80 , you are welcome
