array formular

  • Thread starter Thread starter seemenow
  • Start date Start date
Hi,

AFAIK, you can't.

Give your intent and actual 'non-working' formula, maybe we could help. :-)

Regards,

Daniel M.
 
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?
 
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.
 
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.
 
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.
Click to expand...
...

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.
 
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.
 
Back
Top