Hi all,
I am trying to work out how to calculate length of service into different age brackets. I have attached a simple excel example to hopefully help explain.
What I need is a calculation that breaks the length of service into the following age brackets
18-21 years
22-40 years
41+ years
This should be capped at a maximum of 20 years working down from the age on leaving.
For example for someone who on leaving is 45 years old and has 25 years service their breakdown would be
18-21 years 0
22-40 years 16
41+ years 4
I have been trying to come up with some sort of calculation but this is above my ability and haven't got close. It is also quite tricky to explain like this so feel free to tell me if this makes no sense.
Many thanks to anyone that can help
Tom
I am trying to work out how to calculate length of service into different age brackets. I have attached a simple excel example to hopefully help explain.
What I need is a calculation that breaks the length of service into the following age brackets
18-21 years
22-40 years
41+ years
This should be capped at a maximum of 20 years working down from the age on leaving.
For example for someone who on leaving is 45 years old and has 25 years service their breakdown would be
18-21 years 0
22-40 years 16
41+ years 4
I have been trying to come up with some sort of calculation but this is above my ability and haven't got close. It is also quite tricky to explain like this so feel free to tell me if this makes no sense.
Many thanks to anyone that can help
Tom