Formula to spread number across
Hi,
I want to set up a formula which divides the remaining dollars left by
remaining workdays left for a period specified. If the date goes over
12/31/05, I want it to stop calculate.
For example, the remaining dollar is 30,000. The period is 03/01/05 to
01/01/06.
Thanks!
|