Days are accrued from hire date and start immediately. Anniversary date would be the year that the days start accruing again.

Foxguy, your correct. If his anniversary year goes from 5/3/09-5/2/10 and doesn't take any days, he looses 10 days and will start accruing again on 5/3/10. Then on 5/23 he would have .55 days available again accruing from 5/3/10-5/23/10.


Would it be possible to create a formula in "Days Taken" off if I run a master report out of a database to pull only the days taken off during their anniversary interval...example below...

Jim took 2 days off. One in 1999 and the other in 2010. His anniversary year goes from 5/3/09 to 5/2/10 and then resets. I would want the # of days off of 1 to only pull to the consolidated tab within his anniversary interval. I would have a 2nd tab with the days off pulling to the "Day's Taken" section.

Employee Name Year Taken off Date Taken off # of Days
Cindy 2009 1/1/10 1
Bob 2008 4/1/08 0.5
John 2010 2/1/10 1
Joe 2006 4/1/06 0.5
Jim 1999 4/1/99 1
Jim 2010 5/17/10 1

Thank you all for the assistance