May 16 2019 07:26 AM
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 be equal to a date the holiday is observed.
It is for a State holiday in Dec. that varies depending on what day Christmas is(12-25--) of every year.
The State holiday in Dec. works like this.
For example: in 2021 Christmas is on Saturday which will be observed on Friday, therefore the state holiday will be observed on Thursday.
May 16 2019 10:07 AM
That was it!! Thank you so much. You all are GREAT!@Sergei Baklan
May 16 2019 10:29 AM
@drt_80 , you are welcome
May 16 2019 08:56 AM
Solution