Hi Guys,

I was wondering if someone could give me a hand figuring out the logic for this formula.

Basically I need to find when an employees promotion date is I have their start date as well as the number of days worked.

Now I managed to figure out if I did Start Date + 730 - Today() which gave me the number of days til next promotion (the 730 is 2 years the first increment on the promotion scale) then I did the Start Date + Number of days til promotion (calculated from the above formula) to get my promotion date which works but however I need it to check that if they have worked more than 2 years check the next increment on the promotion scale.

If anyone has any thoughts I would be most appreciative it is driving me wild :P.