Vacation Entitlement based on full years of service and odd vacation year

Originally Posted by bferd

Employees who have a start date between May 2nd and April 30th accrue 1 day for each month of continuous service to a maximum of 10 days paid time off.

Don't know if I'm reading this correctly....

Do you mean that employees who have less than 1 years service get the 1 day per month, otherwise they get the days per full year as you have defined?

If so try this formula

=IFERROR(LOOKUP(DATEDIF(C9,B4,"y"),{1,5,10,18;10,15,20,25}),MIN(10,DATEDIF(C9,B4,"m")))