Hi,
I have an assignment required to find missing weekdays exclude weekends. The dataset has Date at column A, starting from 1/2/2002 at A3. The formula I used was
IF((OR($A4=$A3+1, $A4=$A3+3)),TRUE,FALSE)
Where the formula returns FALSE for missing weekdays. I wonder is this the correct way?
Thank you in advance for your help!
Bookmarks