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
|