Quick question with a formula

[figuare9]

Trying to get excel to work out a formula for us, but I'm having a hard time setting it up.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Hire Date[/TD]
[TD]Journeyman Date[/TD]
[TD]Current %[/TD]
[/TR]
[TR]
[TD]11/1/2018[/TD]
[TD]11/1/2020[/TD]
[TD]???[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.

 

[Eric W]

Try:

	A	B	C	D
Hire Date	Journeyman Date	Current %

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]11/1/2018[/TD]
[TD="align: right"]11/1/2020[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.679685[/TD]

</tbody>

Sheet3​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=MIN(1,65%+(TODAY()-A2)/(B2-A2)*35%)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[figuare9]

This was perfect. Thank you soo much for the help!!

 

[Eric W]

Glad to help!