Hello

My basic excel skills have rather defeated me and I'm hoping some expert might be able to help. I need to calculate redundancy pay for a number of colleagues, it's not based on statutory but company figures of


up to 22 years old 1.5 weeks pay
After 22nd birthday and up to 41st birthday 2 weeks pay
After 41st birthday 2.5 weeks

There are no limits on the maximum payment my data is in the format below is there an easy way to calculate this


Name DOB DOJ Salary
Jo Bloggs 25/12/1985 25/08/2012 35000
Jane Bloggs 31/12/1975 01/01/1995 40000
Jack Bloggs 01/05/1995 12/10/2018 20000

I'd really appreciate any help

Thanks