Vacation accrual calculator

I work for a samll company with few emplyees. I need to manually calculate their vacation used and earned. I am looking for an excel spreadsheet to calculate vacation earned.
We are paid every week.
2 employees receive 5 Weeks of vacation and 6 receive 4 weeks. Vacation runs from May 1st through April 31st. How much would they earn on a daily basis.