Highlight on Date Problem

[Lise]

Hi everyone

I have the following in conditional format in column A

=I54-TODAY()<=60 if true highlight Red

This is working in most cases but for some reason when september dates are
in the I column they also highlight red which is incorrect - am I missing
something in the formula please?

 

[Fred Smith]

Your formula is valid. An incorrect year will cause the problem stated. Are
you entering 2010, as opposed to 2009, or even 1910?

Regards,
Fred

 

[Lise]

Hi Fred

Yes the year is correct 2010. Only happening on month of September - very
annoying.

 

[Fred Smith]

There's got to be something we're not seeing. When you format I54 to
General, what's the number that gets displayed?

Fred