Forum Discussion
Anniversary Date Increase based on Step
You hint--and I do mean hint, as opposed to "describe in detail"--at a number of rules or guidelines here, operating in combination with one another. Length of time, length of time vis-a-vis a hire date and month, a max for step level increase, but also something about if the position is vacant then a 1....
It is next to impossible to write a formula that covers what is not understood. No, correction: it is impossible.
Please understand, I was (before retiring two decades ago) the director of the HR/Payroll database for a major US corporation, so I've dealt with salary systems and anniversary dates and so forth before. If I'm having trouble understanding what you've written, you can be pretty sure that most others will too.
It sounds as if you might have a spreadsheet already doing a small part of what you want to do. Could I ask that you post a copy of that (with no real names or other identifiable details; but with enough so we can understand what you've done so far)...post it on OneDrive or GoogleDrive with a link pasted here that grants access.
Then, along with the link that grants access, do your best to spell out in more details all of the factors that enter into salary increases based on steps and anniversary dates. Don't assume it's all obvious, no matter how clear it is to you.