money/date calculation

[anathemayou]

Can anybody help me with this formula for subtracting date/money?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

It seems easy but it’s a mind cruncher!!!
<o></o>
A1 - 64.0$ (expenses per day,number is changing its not constant) <o></o>
<o></o>
A2 - =NOW() (shows current date and year in spreadsheet)
<o></o>
A3 - 9000$ (amount of money on account)
<o></o>
A4 - ??????? ( here I need to show me the actual date when will I run out of money)
<o></o>
<o></o>
I am trying to get process information when will I run out of money (that 9000) .
and to show it in cell A4.<o></o>


There does not seem to be a direct function to carry this operation out.

Any ideas/suggestions would be most welcome

Im loosing my mind here with this

Thank You<o></o>

 

[JamesW]

Would this have the desired effect?

=A2+(A3/A1)

 

[scottylad2]

Surely it 9000/A1, which rounds to 140.6 then add that to your starting date. If date is 3/11/2010 then add 140.6 to that. You will need to hard code your starting date though, the Now function is a volatile function that will change everytime your sheet is open or updated.

 

[anathemayou]

Here is additional clarification

A1 - 64.0$ (expenses per day,number is changing its not constant) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
A2 - =NOW() (shows current date and year in spreadsheet also can not be constant )
<o></o>
A3 - 9000$ (amount of money on account is never constant )
<o></o>
A4 - ??????? ( need actual date when will I run out of money also is going to be variable 'cause all above are as'well)



like i said, its a mind cruncher ...

help !!!

 

[JamesW]

Sorry but I don't understand.

=A2+(A3/A1) means that it adds any date in cell A2 to any amount of money divided by any expenses value.

If you put £9000 in cell A1, and have today's date in cell A2, the result would be "06/11/2010" - meaning you will run out in 1 day.

If you put £4500 in cell A1, and have today's date in cell A2, the result would be "07/11/2010" - meaning you will run out in 2 days.... etc..

 

[scottylad2]

If you use the now function you will never be decreasing. You either need a hard coded start or end date. A1/A3 will give you an absolute number of days dividing your pot by daily expenses. It equates to 140.6 days. You only need to add that to your start date. I'd use Today as opposed to Now, because that includes a time element that will change constantly

 

[anathemayou]

whats the difference betwen =NOW and = TODAY
??

I've just imputed **JamesW** formula again and (now?!) it works - or it looks like it works !!!

you are very smart ... if i shown you what kind of operation i did and emulate from the web to get this .... you guys would crack up..


THANK YOU !!!! ray:

 

[scottylad2]

The difference between Today & Now is today is the date only, and Now includes the time. =now() will return 5/11/2010 12:43 where today will return date only. If you put =now in a cell on its own, tap F9 and youll see it changes every time you repeat that. The time parts not required for what your doing

 

[anathemayou]

Understand now... yes i dont need that in this case ....

Thank you both so much