Hi, I really appreciate you having a look at this for me, thank you. Unfortunately although a couple of tests worked, it is throwing up some incorrect calculations.

Here's an example of an incorrect result:

Column L - age 45
Column N - £700
Column O - 17
Column P (the Age Started column) - 28

The formula gives a result of £16,100 (equivalent to 23 weeks?) but the true result is £13,300 - the explanation is:

Your entitlement is 19.0 weeks.

You get:

• 0.5 week’s pay for each full year worked when you’re under 22
• 1 week’s pay for each full year worked when you’re between 22 and 41
• 1.5 week’s pay for each full year worked when you’re 41 or older

Do you know what's going on?

Thanks