Hi

I am trying to calculate the promotion date that each employee will gain promotion to the next grade

G1: Less than 2 years service / Salary £12582
G2: 2 – 5 years / Salary £16647
G3: 6 – 10 years / Salary £20145
G4: 10 years or more / Salary £25687


What I wanted to do is to find out the date which each employee will gain the next promotion to a different grade

I can attach the file itself it needed

Thank you.