Forum Discussion
Solved
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. Holi...
Try this formula:
=IF(ISERROR(MATCH(TODAY(),Cmd!$A$6:$A$17,0)),TODAY()=TODAY()+7-WEEKDAY(TODAY(),16)-ISNUMBER(MATCH(TODAY()+1,Cmd!$A$6:$A$17,0))-ISNUMBER(MATCH(TODAY()+2,Cmd!$A$6:$A$17,0)))
Try this formula:
=IF(ISERROR(MATCH(TODAY(),Cmd!$A$6:$A$17,0)),TODAY()=TODAY()+7-WEEKDAY(TODAY(),16)-ISNUMBER(MATCH(TODAY()+1,Cmd!$A$6:$A$17,0))-ISNUMBER(MATCH(TODAY()+2,Cmd!$A$6:$A$17,0)))
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!
Thank you!