Trying to get excel to work out a formula for us, but I'm having a hard time setting it up.
<tbody>
</tbody>
Our new hires start out at 65% Journeyman waige, and over two years their wages will increase until they reach 100%. So essentially, they start out at 65% and two years later, they'll end up at 100.
what's the best way to get excel to tell me what % they are from todays date? I've spent a bit of time trying this one with no luck.
Hire Date | Journeyman Date | Current % |
11/1/2018 | 11/1/2020 | ??? |
<tbody>
</tbody>
Our new hires start out at 65% Journeyman waige, and over two years their wages will increase until they reach 100%. So essentially, they start out at 65% and two years later, they'll end up at 100.
what's the best way to get excel to tell me what % they are from todays date? I've spent a bit of time trying this one with no luck.