S
seemenow
How can I enter an array formular with the NETWORKDAYS
FUNCTION?
FUNCTION?
D
Daniel.M
Hi,
AFAIK, you can't.
Give your intent and actual 'non-working' formula, maybe we could help.
Regards,
Daniel M.
AFAIK, you can't.
Give your intent and actual 'non-working' formula, maybe we could help.
Regards,
Daniel M.
S
SEEMENOW
Pls see the below formula:
=Networkdays(A12,B12)-1 - Works fine in a single cell.
My intent is to use the above formula in an array,
=Networkdays({A12:A50,B12:B50})-1
Is this possible?
=Networkdays(A12,B12)-1 - Works fine in a single cell.
My intent is to use the above formula in an array,
=Networkdays({A12:A50,B12:B50})-1
Is this possible?
D
Daniel.M
Hi,
Since you are not using holidays, try the following array formula
(Ctrl-Shift-Enter):
=SUM(INT((B12:B50-WEEKDAY(B12:B50-{1,2,3,4,5})-A12:A50+8)/7))-ROWS(B12:B50)
Regards,
Daniel M.
Since you are not using holidays, try the following array formula
(Ctrl-Shift-Enter):
=SUM(INT((B12:B50-WEEKDAY(B12:B50-{1,2,3,4,5})-A12:A50+8)/7))-ROWS(B12:B50)
Regards,
Daniel M.
S
SEEMENOW
Tried both formulas form posting. Both resulted in an
error message, #num.
My guest is, my example was unclear. Therefore, let's try
again, please.
My intent is to subtract a beginning date and an end date
minus -1 day, excluding weekends.
beginning date ending date results
A12:A50 B12:B50 C12:C50
8/1/03 8/3/03
8/5/03 8/8/03
My result cell should be something like
C12 2 as answer
C13 3 as asnwer
Thanks in advance for any help you can suggest.
error message, #num.
My guest is, my example was unclear. Therefore, let's try
again, please.
My intent is to subtract a beginning date and an end date
minus -1 day, excluding weekends.
beginning date ending date results
A12:A50 B12:B50 C12:C50
8/1/03 8/3/03
8/5/03 8/8/03
My result cell should be something like
C12 2 as answer
C13 3 as asnwer
Thanks in advance for any help you can suggest.
H
Harlan Grove
...
Your pervious information was sufficient. I simply screwed up my formula. Make
it
=MMULT(INT((B12:B50-WEEKDAY(B12:B50-{1,2,3,4,5})-A12:A50 +8)/7),
ROW(B12:B50)^0)-1
It's an array formula returning an array result, so you need to select C12:C50,
type in this formula, then hold down [Ctrl] and [Shift] keys before pessing the
[Enter] key.
D
Daniel.M
Hi Harlan,
I'm back and I see you read the OP request correctly.
I always thought he wanted one result (scalar) and I was wrong.
Just as an alternative, he can put (In C12, and copy to Cx):
=SUM(INT((B12-WEEKDAY(B12-{1,2,3,4,5})-A12+8)/7))-1
Anyway, thanks for following up.
Daniel M.
I'm back and I see you read the OP request correctly.
I always thought he wanted one result (scalar) and I was wrong.
Just as an alternative, he can put (In C12, and copy to Cx):
=SUM(INT((B12-WEEKDAY(B12-{1,2,3,4,5})-A12+8)/7))-1
Anyway, thanks for following up.
Daniel M.