Thread: Conditional Formatting not giving correct answer...

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?

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.

LOL! Thanks a bunch

"dpaguy" wrote:

>
> 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.
>
>
> --
> dpaguy
> ------------------------------------------------------------------------
> dpaguy's Profile: http://www.excelforum.com/member.php...o&userid=30191
> View this thread: http://www.excelforum.com/showthread...hreadid=498713
>
>