How to Forecast end date?

[Jon]

Greeting,

I have a mount of money that I want to be distributed per month. For
example, if I have 10000USD and I want to be distributed effective Jan 2009
by 1000 per month. What I want to know is the last month of the last monthly
amount. How to do that?

 

[Ron@Buy]

Jon a very simple solution:
Input data as follows:
Cell A1 10000
Cell A2 1000
Cell A3 1/1/2009
Cell A4 the formula =A1/A2*30+A3 and custom format the cell as mmm yyyy
This will give you the answer to your question but I suspect that your
actual data may be as simple as listed in your question!

 

[Max]

One thought
In A1: 10000
Then in B1:
=TEXT(DATE(YEAR(--"Jan 2009"),MONTH(--"Jan 2009")+A1/1000-1,1),"mmm yyyy")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik

 

[Ron@Buy]

Jon
A simple solution:
Cell A1 10000
Cell A2 1000
Cell A3 1/1/2009
Cell A4 the formula =A1/A2*30+A3 an custom format mmm yyyy
This will give you the answer to the data listed in your question but I
suspect that your true data is not quite so simple!
Hope this helps