Need formula to accrue vacation time

[Stephanie8707]

I need help with a formula to accrue vacation time for numerous employees.
This is the cells I currently have built. If you think I need other ones please advise.
[TABLE="width: 1105"]
<tbody>[TR]
[TD]Employee Names[/TD]
[TD]Start Date[/TD]
[TD]Today[/TD]
[TD](MPC) Vacation Accrued[/TD]
[TD](Rollo) Vacation Accrued
[/TD]
[/TR]
</tbody>[/TABLE]
For MPC Vacation time employees get 1 week paid vacation or 40 hours once they make 5 years with the company.
For Rollo Vacation Time Employees get 1 week paid vacation or 40 hours once they make 1 year with the company.

I know this would end up being two different formulas. Please help =)

 

[mopp1]

Assuming start date is in B2 and Today's date is in C2
and that you want MPC Vac to either be 40 or 0 depending on whether the employee has 5 or more years or not:

=IF(DATEDIF(B2,C2,"Y")>=5,40,0)

for Rollo change the 5 to 1