Not knowing what exactly you are tracking or how you have it layed out the
best I can offer is that you need a multipart calculation. First, you need a
=today() formula to calculate when, in your example, Dec 10 is.
Then, in your example, in cell A1 you need to have an IF statement to
measure against your =today() formula for the Dec 10 date.

IF this is helpful but not helpful enough please let me know. I know with
the file in front of me I can build it, I have one for my personal tracking
that calculates my hourly acrual of vacation time, makes the adjustment to
the rate for my anniversary, and accounts for how much I have taken. I'd be
happy to share my file so you can get an idea on how I tackled this.

"jopla" wrote:

I am using a vacation tracker spreadsheet to record vacations used. On an
employee's anniversary date, they have vacation time added. Can I create a
formula that will add their newly allowed vacation time to a cell, on their
anniversary date?

Example. On December 10 add 10 days (or hours or shifts) to Cell A1.
Thanks....