#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Perhaps =AND($F4<>"Paid",(TODAY()-$E$4)>=6)
etc.. and check "Stop..." (don't remember the line..
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Please see attached sample sheet.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with Dates | Eric Tsang | Excel | 1 | 09-30-2016 11:26 AM |
Autofill dates - how can I get the same date and consecutive dates? | Exhale | Excel | 3 | 04-05-2016 03:11 AM |
Changing Actual Finish dates changes original Finish dates | SomewhereinTX | Project | 3 | 12-20-2013 10:25 AM |
Code to add dates | terricritch | Excel Programming | 10 | 11-08-2011 09:51 AM |
Calculating dates | Daria11 | Word VBA | 1 | 06-08-2011 06:54 PM |