Thread: CF for due dates
View Single Post
 
Old 10-10-2017, 09:50 PM
mikehk mikehk is offline Windows 10 Office 2013
Novice
  
Join Date: Sep 2017
Posts: 15
mikehk is on a distinguished road
Default CF for due dates
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
Reply With Quote