Countdown

[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?

 

[Maistrye]

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

 

[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"

 

[Maistrye]

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

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

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

My apologies.

Scot

 

[simserob]

Thanks, that worked. But it puts it in a regular date format, is there
any way i could get it like 59 days left or something?
Also i still need a way to calculate the average amount per day by
making a reference to the first day and dividing the total amount
earned by the number of days since the start.

Btw, thank you so much for your help with this, i really appreciate it

 

[simserob]

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