Forum Discussion
Help !!! Formula required
Hey Guys,
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".
2 Replies
Perhaps the attached example workbook contains the formulas that you need.
- 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”))
