Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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. "JN" wrote: 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! |
#3
|
|||
|
|||
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. "JMB" wrote: 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. "JN" wrote: 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! |
#4
|
|||
|
|||
Please disregard my other response. The formula works well. Thanx!
"JMB" wrote: 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. "JN" wrote: 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! |
#5
|
|||
|
|||
you're welcome!
"JN" wrote: Please disregard my other response. The formula works well. Thanx! "JMB" wrote: 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. "JN" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify if Cell is Formula or written number | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I enter formula using % > or < = number? | Excel Worksheet Functions | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) |