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.


--
dpaguy
------------------------------------------------------------------------
dpaguy's Profile: http://www.excelforum.com/member.php...o&userid=30191
View this thread: http://www.excelforum.com/showthread...hreadid=498713

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