Hello all,

I've been banging my head against a wall for a while on this one, so any tips/suggestions would be greatly appreciated.

I need to develop a spreadsheet that tracks my company's vacation accrual. The accruals go like this:

Employed less than 1 year gets 1 vacation day per quarter starting the next full quarter
On 1st year anniversary date, instantly 5 days vacation plus the 1 per quarter accrued
On 2nd year anniversary date, instantly 10 days vacation plus the 1 per quarter accrued

Ex: Johnny is hired on Feb 21, 2011 which is during qtr 1. So beginning April 1, he gets 1 day for qtr 2, on July 1 he gets a day for qtr 3... etc. And on Feb 21, 2012 he immediately gets 5 days while still accruing 1 per quarter.

If anyone can provide a formula that automatically updates the quarterly accruals I would be more than happy! I can do the anniversary 5 or 10 days manually if necessary, we don't have that many employees. I just gotta have something for the accruals!