Need Help on Excel formula


Hi all,

I have this formula located in Conditional Formatting (as shown below). It highlights the cell on every Fridays. If the Friday is a holiday, it highlights the next workday e.g., Monday. Holidays are in Cmd worksheet. I would like to modify it by highlighting the cell the day before the holiday e.g., Thursday or Wednesday in case of Thu and Fri are consecutive holidays. Thanks in advance, I will greatly appreciate any help in this regard.



2 Replies
best response confirmed by A2Z CF (Contributor)

@A2Z CF 

Try this formula:



Awesome! What a great formula. It solved the problem. I appreciate it thank you so much for solving my problem. May the power be with you!
Thank you!