View Single Post
Old 02-10-2013, 01:19 PM   #54
tarisea
Connoisseur
tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.tarisea got an A in P-Chem.
 
Posts: 85
Karma: 6288
Join Date: Dec 2012
Device: iphone
Chaley the wording is seriously misleading and almost impossible to work with. I have run a few tests and this is what I figured out.

The condition is defining "not more days ago than" as any time in the future up to x number of days in the past from today.

The conditions needed is one that will equal any time in the past. Very simply "is less than today"

So basically on February 10, 2013:

4/2/2001 =IF(A1<TODAY(),true,false) TRUE icon
2/2/2012 =IF(A1<TODAY(),true,false) TRUE icon
11/10/2012 =IF(A1<TODAY(),true,false) TRUE icon
5/5/2013 =IF(A1<TODAY(),true,false) FALSE no icon
2/8/2013 =IF(A1<TODAY(),true,false) TRUE icon
tarisea is offline   Reply With Quote