Future Expected Value Date

[isleofman]

How would I create a formula to calculate the expected date to achieve a value from the following information?

Todays Date: 25/5/2011
Current Value: 123000
Target Value: 200000
Current Growth Per Day: 123

How would I reach a result where I could know for example - 25/12/2011 would be the date where I would achieve or surpass the 200000 value?

Many thanks!

 

[JD_GFI]

A simple formula should do the trick.

=B1+(ROUNDUP(((B3-B2)/B4),0))

B1 = Todays Date
B2 = Current Value
B3 = Target Value
B4 = Growth Per Day

Cell with formula entered must be formatted as a date for it to show correctly.

 

[isleofman]

Many thanks!