NETWORKDAYS FUNCTION, Help please
 

Hello All,

How can I use the networkdays function to count the number of workdays
between two given days with 2 conditions attached?

Example: How many workdays are there between date1 and date2 while
Range1 = "masonry" and Range2="John Smith"?

Thanks for your help.

BC

NETWORKDAYS FUNCTION, Help please
 

You don't explain how the conditions relate to the dates. Does each item in
the ranges have start and end dates associated with them or what?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"BiggyTwo" wrote in message
oups.com...
Hello All,

How can I use the networkdays function to count the number of workdays
between two given days with 2 conditions attached?

Example: How many workdays are there between date1 and date2 while
Range1 = "masonry" and Range2="John Smith"?

Thanks for your help.

BC

NETWORKDAYS FUNCTION, Help please
 

Hi Bob,

Thanks for your time.

John Smith is one of several multiskilled employees on a project. The
aim is to count the number of normal workdays that any employee (John
Smith etc.) works as a mason, welder etc.
That is the conditions a-
1) The employee name, e.g. "John Smith" and
2) The discipline he worked in, e.g. "masonry"

(Not sure I understand your question but hope that the short
explanation helps.)

Best wishes,

bc

NETWORKDAYS FUNCTION, Help please
 

Bob is right, more info would be helpful but I made an assumption. My
table is set up as follows to make this formula work.

Column A = Start Date, Column B = End Date, Column C = Networkdays,
Column D = Type of work (masonry, carpentry), Column E = Contractor

Then I applied this formula which counts the number of times the
networkdays is greater than 10 where John Smith was the contractor
performing masonry work.

=SUMPRODUCT((C2:C710)*(D2:D7="masonry")*(E2:E7="J ohn Smith"))

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=527585

NETWORKDAYS FUNCTION, Help please
 

Based on your last post, if you use a table set up as I said then,

=SUMPRODUCT((D2:D7="masonry")*(E2:E7="John Smith")*C2:C7)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=527585

NETWORKDAYS FUNCTION, Help please
 

=NETWORKDAYS(INDEX(C1:C15,MATCH(1,(A1:A15="James
Smith")*(B1:B15="masonry"),0)),INDEX(D1:D15,MATCH( 1,(A1:A15="James
Smith")*(B1:B15="masonry"),0)))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"BiggyTwo" wrote in message
oups.com...
Hi Bob,

Thanks for your time.

John Smith is one of several multiskilled employees on a project. The
aim is to count the number of normal workdays that any employee (John
Smith etc.) works as a mason, welder etc.
That is the conditions a-
1) The employee name, e.g. "John Smith" and
2) The discipline he worked in, e.g. "masonry"

(Not sure I understand your question but hope that the short
explanation helps.)

Best wishes,

bc

NETWORKDAYS FUNCTION, Help please
 

Hello all,
Once again thanks for your time. I shall give the problem another try,
perhaps change the spreadsheet if I am allowed to get the desired
results. There must be a way.

Just a little note:
ColumnA contains all the Dates anyone worked (Sun to Sat).
ColumnD contains the names
ColumnG contains the discipline, eg masonary.
I would like to count the weekdays, less holidays, that John performed
masonry, etc. then expand to other combinations.

Appreciate your time, sorry I wasted so much of it though.

b

NETWORKDAYS FUNCTION, Help please
 

Did you see my follow-up response?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"BiggyTwo" wrote in message
oups.com...

Hello all,
Once again thanks for your time. I shall give the problem another try,
perhaps change the spreadsheet if I am allowed to get the desired
results. There must be a way.

Just a little note:
ColumnA contains all the Dates anyone worked (Sun to Sat).
ColumnD contains the names
ColumnG contains the discipline, eg masonary.
I would like to count the weekdays, less holidays, that John performed
masonry, etc. then expand to other combinations.

Appreciate your time, sorry I wasted so much of it though.

b

NETWORKDAYS FUNCTION, Help please
 

On 29 Mar 2006 09:04:54 -0800, "BiggyTwo" wrote:


Hello all,
Once again thanks for your time. I shall give the problem another try,
perhaps change the spreadsheet if I am allowed to get the desired
results. There must be a way.

Just a little note:
ColumnA contains all the Dates anyone worked (Sun to Sat).
ColumnD contains the names
ColumnG contains the discipline, eg masonary.
I would like to count the weekdays, less holidays, that John performed
masonry, etc. then expand to other combinations.

Appreciate your time, sorry I wasted so much of it though.

b


=SUMPRODUCT((WEEKDAY(Dates,3)<5)*ISNA(MATCH(
Dates,Holidays,0))*(Names="George")*(Discipline="P lumbing"))

You'll need a range with the Holiday dates.

You can also substitute cell references for the other named ranges (Dates,
Names, Discipline) but be aware that the ranges cannot include an entire column
and these three must be the same size.

You can also put George and Plumbing in some cell to make it easier to change
the parameters.


--ron

NETWORKDAYS FUNCTION, Help please
 

Hi All,

Thanks one more time. The posts from Ron and Bob offer the most
promise. After a bit of *distillation* I shall confirm in another 24
hours.

Regards,

b