I have been racking my brains out, I have employees with senority that the
vacation is based on years employed.

If the employee has 1-3 years in, he gets 1 week vacation,
If the employee has 4-8 years in, he gets 2 weeks vacation.
If the employee has 9-15 years in, he gets 3 weeks vacation.
If the employee has 16-20 years in, he gets 4 weeks vacation
If the employee has 21-25 years in, he gets 5 weeks vacation

How can I make excel pick up the number of years worked and just print the
number of weeks vacation the employee would receive?

I know it can be done, I did it before, but I lost the spreadsheet and I
just can't remember how I did it.

Old age is sneeking up on me!!

Thanks Steve
--
Steve