Conditional Formatting not giving correct answer...

[Guest]

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?

 

[dpaguy]

reverse the order of the date computation i.e, 1/6/2006-12/20/2005 .
This result is positive number ; your result will give a negative
number which Excel can't interpret. Dates are converted to days since
1/1/1900 before being operated on.

 

[Guest]

LOL! Thanks a bunch