Growth Over Time - Have Start & End Value only

[slstewart249]

Hi - I am trying to figure out how to write a formula for linear growth.

I have a Start Value of 1 and End Value of 5,000,000,000. The Start value is in Current month Aug 2018 and the End Value is in month Dec 2025.

Not sure where to start - growth, forecast, interpolation?

Please help!

 

[Hui]

G6: =F6+($C$6-$B$6)/DATEDIF(DATE($F$4,$F$5,1),DATE($M$4,$M$5,1),"m")
Copy across

This breaks down as:
($C$6-$B$6)/DATEDIF(DATE($F$4,$F$5,1),DATE($M$4,$M$5,1),"m")
($C$6-$B$6) = Quantity per month
DATEDIF(DATE($F$4,$F$5,1),DATE($M$4,$M$5,1),"m") = No of Months = 88

 

[slstewart249]

This is great! However, I think I worded my question wrong. I am looking to determine the value (ie. # of parts sold) so that I start selling parts in 8/2018 and by 12/2025 have sold, cumulatively, 5 Billion parts.

Start value 1
Cumulative end value 5Billion

Thanks

 

[Hui]

So its the last bit of the formula
=($C$6-$B$6)/DATEDIF(DATE($F$4,$F$5,1),DATE($M$4,$M$5,1),"m")
=56,818,181.8 per month for 88 months