How to stop vacation hours calculation on vacation day

solved:
http://www.excelforum.com/excel-prog...-schedule.html

old:
I have been posting some thoughts here... but have a new dilema:
in my other post i am focusing on creating a reset button.

what i didn't realize is that my current funcation that calculates vacation hours... will increase after a new year. i'd rather have it not increase until they are "reset" for the new year.

how do i stop the function?


=VLOOKUP(DATEDIF(A8,TODAY(),"y"),$S$8:$T$10,2)

basically goes to a lookup table with the caculations.

PROBLEM: if a user's anniversery date passes, they may go from a 1-2 year status to 3 year bump... this will auto adjust the amount of vacation hours they have.

if the reset button is ran to calculate the vacation hours, it might over calculate giving the user 40+ extra carryover hours.

anyway i can make this vlookup stop when the current date is or has passed the anniversery date, yet has not been reset? maybe a count down timer, not sure.
http://www.ozgrid.com/News/excel-eva....htm#ExcelTips