CF for due dates

[mikehk]

I have tried these formulas but doesn't work...please help.


cell E4 has a due date (5 Oct 2017)

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>=6) for orange

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>=3) for blue

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>0) for green

[Pecoflyer]

Perhaps =AND($F4<>"Paid",(TODAY()-$E$4)>=6)
etc.. and check "Stop..." (don't remember the line..

[mikehk]

Originally Posted by Pecoflyer

Perhaps =AND($F4<>"Paid",(TODAY()-$E$4)>=6)
etc.. and check "Stop..." (don't remember the line..

Please see attached sample sheet.