Countdown

Hey, I have excel 2000 and here's what i'm making and what my problem is:

basically, i'm trying to collect a certain amount of money in a certain amount of time and i'd like to make it so it calculates how much i've gotten from day 1 and figures out how many more days it will take for me to reach my goal...
hope you can get that.

in short, what i need is a countdown function like
=today()+(amount of days it will take with the average money made per day)
...or kind of like that.

can anyone help me?

Originally Posted by simserob

Hey, I have excel 2000 and here's what i'm making and what my problem is:

basically, i'm trying to collect a certain amount of money in a certain amount of time and i'd like to make it so it calculates how much i've gotten from day 1 and figures out how many more days it will take for me to reach my goal...
hope you can get that.

in short, what i need is a countdown function like
=today()+(amount of days it will take with the average money made per day)
...or kind of like that.

can anyone help me?

Try = today()+CEILING(AmountNeeded/AverageAmountPerDay)

Where AmountNeeded and AverageAmountPerDay are references to whereever you have them.

Scott

when i do that it says there's an error - i guess it doesn't recognize the significance of the numbers...i also would need a day counter to get the average amount earned per day.
i think with the formula you gave me, it wouldn't come out to an amount of days...i'm not really sure though since i've never heard of the command "ceiling"

Originally Posted by simserob

when i do that it says there's an error - i guess it doesn't recognize the significance of the numbers...i also would need a day counter to get the average amount earned per day.
i think with the formula you gave me, it wouldn't come out to an amount of days...i'm not really sure though since i've never heard of the command "ceiling"

Sorry, I forgot to put the significance into that equation. :-P

Try = today()+CEILING(AmountNeeded/AverageAmountPerDay,1)

My apologies.

Scott

Yeah, now it works
Thank you very much for your trouble, i really appreciate it