Accural spreadsheet
 

How do I create an vacation accural spread sheet in excel?
I need something that I can enter the hire date and it will calculate the
vacation and subtract the vacation used to give the total. Can anyone help?
The info I have is:
1st yr - 1 week
2nd - 10th - 2 weeks
10th + 3 weeks

1st yr @ .77 - per pay period
2nd - 10th @1.54 per pay period
10th + @2.31 per pay period