The following conditional format formula highlights cell Q6 if the date in the cell is the day before yesterday or earlier. Is there a way to change this formula to exculde weekends and holidays similar to the WORDAY function?
The purpose of the formula is to check if a specific specfic macro, which pastes the current date into cell Q6 was run on the previous business day
=Q6<TODAY()-1
Bookmarks