Calculating promotion date

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.

Hello
Try the EDATE function, for example if the employee's start date was in cell A2:

Formula:

Please Login or Register  to view this content.

This would give the date of 2 year's service, adjust the 24 to 72 and 120 respectively.

Hope this helps.
DBY

Originally Posted by DBY

Hello
Try the EDATE function, for example if the employee's start date was in cell A2:

Formula:

Please Login or Register  to view this content.

This would give the date of 2 year's service, adjust the 24 to 72 and 120 respectively.

Hope this helps.
DBY

Thank you for helping me with this issue

I tried this function and it works fine, but I would like to improve on this future. For example I would like to use a VLOOKUP function to bring in the dates.

From what I can understand to use the VLOOKUP function should I just put the amount of months till the next promotion then use the EDATE function with a VLOOKUP?

Originally Posted by DBY

Glad you found it useful. You can replace the A2 reference in my example with the VLOOKUP function, as long as it returns a valid date it should still work okay. For example:

Formula:

Please Login or Register  to view this content.

DBY

Hi

This is the formula that I got to work
=IF(O3="G4","N/A",LOOKUP(L3,Paygrade!$A$2:$A$12,Paygrade!$D$2:$D$12))

It works but I would like to improve on it, the EDATE function, any way you can help me with that please?

Thanks