Well, my search has come to an end, I have found many "skip weekends" and count the next day (Monday if it is Friday), but what I am looking to do is highlight the next workday (Monday through Friday), but come Thursday, highlight both Friday AND Monday.
This works well to highlight the next workday, but how do I extend it to the following Monday as well?
This works well to highlight the next workday, but how do I extend it to the following Monday as well?
Code:
=IF(TODAY()+1=WORKDAY(D1,0,2),TODAY()+1,"")