I posted here a few weeks ago with a very similar issue- http://www.excelforum.com/showthread.php?t=494904

I just recently learned that we need to add a similar policy for our office employees. This is very similar to my earlier post but they are some differences. Here is the criterion for the office employees:

*During the first calendar year vacation will accrue at 5/12 days (3.34 hours) per complete month of service.
*Beginning January 1st following the date of hire the employee will receive two weeks (80 hours) each year.
*Beginning January 1st following the date of hire the employee will receive three weeks (120 hours) each year.
ANY help would very appriciated! Thanks!