Calculating Future Goal Time Period

[piptendo]

Hi there,

New user; I've checked all the forums and couldn't find anything which was close to the issue I'm having and hoping to solve as I've seen a past colleague do so with excel.

See below and example of the data that I have -

Is there a formula to calculate how many months would be required to reach the goal of 98% if everything (fingers crossed) increases by .5% each month?

Also, would there be a formula which can predict using the data above what percentage the route would be on-time wise (which is the percentages) in April of 2021?

Any help would be much appreciated and I do hope I have explained this correctly and clearly.

Many thanks

 

[Dave Patton]

T202009b.xlsm
	A	B	C	D	E
1		Goal	98.0%	12	Apr-20
2	Route	Apr-19	May-19	Jun-19	Jul-19
3	201	92.4%	92.9%	93.4%	93.9%
1d

Cell Formulas
Range	Formula
D1	D1	=ROUNDUP((C1-B3)/0.005,0)
E1	E1	=DATE(YEAR(B2),MONTH(B2)+D1,1)
C3:E3	C3	=B3+0.005

 

[piptendo]

Thank you immensely!

 

[Dave Patton]

Thanks for the feedback.

 

[Dave Patton]

The second part of your question may be included in this post.

T202009b.xlsm
	A	B	C	D	E	F
1	Goal	98.0%	Apr-20	Apr-21	% Est -->	104.4%
2	Route	Apr-19	May-19	Jun-19	Jul-19	Aug-19
3	201	92.4%	92.9%	93.4%	93.9%	94.4%
4
1d

Cell Formulas
Range	Formula
C1	C1	=DATE(YEAR(B2),MONTH(B2)+ROUNDUP((B1-B3)/0.005,0),1)
F1	F1	=DATEDIF(B2-1,D1,"m")*0.005+B3
C3:F3	C3	=B3+0.005