Formula help

[Judimiller]

Hi there, I may be venturing into something way over my head but it's worth a try. I am trying to create a spreadheet for vacation time accruals. Looking something like this.

Jan, Feb March etc. (Across top)
Bal.for,Accrued,Used,Remaining


Employee Hire Date (horizontal)
Tom Huck 6/1/06
Josh Kheng 3/16/04

- Accrued cell should automate based on the below
0-36 mo. accrued = .83 days
37-60 mo accrued = 1.25 days
61 + mo accrued = 1.67 days

- "Remaining" cell should bump up to "Bal.Forward" cell
- "Used" Manual entry

The hard part here is triggering the accruals based on the the hire date. Also tracking in hrs.

Any ideas?

Thanks

[NBVC]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.