Need help as need a formula for which i can get the result stating "Today" being "Due Today ... Yesterday and before that as "Over Due" and Tomorrow and day after as "Future Dated"
Consider today as Monday so Saturday and Sunday along with Monday should be "Due Today".
If Due Date is in A2, the formula in B2 is: =IF(OR(WEEKDAY(A2)={7,1})* (WEEKDAY(TODAY())=2), “Due Today”, CHOOSE(1+(TODAY()>A2)+ (TODAY>=A2), “Due Later”,”Due Today”,”Overdue”))