Formula to spread number across

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
A
1 3/1/05
2 1/1/06
3 30000

=A3/(NETWORKDAYS(A1,MIN(A2,DATEVALUE("12/31/05"))))

Note Networkdays has an optional array argument to include state,federal,and
floating holidays,if you want these excluded.
 
Thanks. Can you tell me what the second part of the formula does - MIN and
Datevalue? This will allow me to change the formula in the future. Thanx.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating date and time 5
Sum value between two dates and copy to new cell 6
Termination within number of days 5
How to get largest date from a Vlookup 1
Sum amount of days in another coloumn 8
Need help w/dates 13
conditional date formula 2
Date formula 4

Back
Top