I am using conditional formatting to set a function that will format a date
if it's above 30 days old.
Ex. - If the date (12/20/05) is over 30 days (1/6/06), turn it orange.
Formula is - (cell for 12/20/05 - cell for 1/6/06) > 30
It turned orange! any reasons why???
Help I dont want to use this conditional formatting if its gonna give back
incorrect results? Could it be the year 2006 throwing it off?
Bookmarks