Quote 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