Excel 2003 SP2
Win XP SP3

I want to compare today's year with a 4-digit number to see if they are the
same.

I tried formatting a cell as "yyyy" and then using =now(). This DISPLAYS
the year, but if I try to compare it to the number I get a mismatch.

Ultimately, I want to display "Updated" in a cell, if today's year is the
same as the 4-digit number in the reference sheet.

I'd prefer a formula over VBA code, but beggars can't be choosers, right? =)

I'd appreciate any pointers to get me started in the right direction. Thank
you.