I'll bite.

What is in H2 and how is it derived?

Are you using =TODAY() or similar?

That is a volatile function which changes daily.


Gord Dibben MS Excel MVP


On Tue, 6 Apr 2010 12:06:14 -0700, RRyan
wrote:

I'm working on a vacation tracker and would like to carry over unused
vacation. My cell formula works on the anniversary day but goes away the day
after. If the month and day = the anniversary than true otherwise false.
=IF(H2=FALSE,"",G2+E2) Any ideas?