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" Consid...
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”))
=IF(OR(WEEKDAY(A2)={7,1})*
(WEEKDAY(TODAY())=2),
“Due Today”,
CHOOSE(1+(TODAY()>A2)+
(TODAY>=A2),
“Due Later”,”Due Today”,”Overdue”))