Calculating no. of working days including saturdays

[howard]

I have the following formula in A2 ="Parts Man Report "&TEXT(NOW(),"dd/mm/yyyy")&""

I would like to set up a formula to computte the number of working days in the month including saturday and exluding public holidays (I would set up a table for the public holidays)

 

[Jonmo1]

Which version of Excel do you have?

And do you mean the Current Month? or some other month otherwise specified?

 

[howard]

Thanks for the reply. Excel 2007. I mean the current month

 

[Jonmo1]

Try this

=SUMPRODUCT(--(WEEKDAY(ROW(INDEX(A:A,G1-DAY(G1)+1):INDEX(A:A,EOMONTH(G1,0))))<>1),--(ISNA(MATCH(ROW(INDEX(A:A,G1-DAY(G1)+1):INDEX(A:A,EOMONTH(G1,0))),F1:F10,0))))

G1: =TODAY()
F1:F10 = your list of holiday dates

 

[howard]

Thanks for the help, much appreciated

 

[howard]

How do I amend formula to only include weekdays (public holidays stiill to be excluded)?

 

[Jonmo1]

How do I amend formula to only include weekdays (public holidays stiill to be excluded)?

So this meaning exclude Saturday AND Sunday?

=NETWORKDAYS(G1-DAY(G1)+1,EOMONTH(G1,0),F1:F10)

G1: =TODAY()
F1:F10 = your list of holiday dates

 

[howard]

Thanks for the help, much appreciated

How does the EOMONTh formula work?

 

[Jonmo1]

Glad to help, thanks for the feedback..

It finds the last day of the month that is the given # of months from a given date.

 

[howard]

Thanks, I thought this may be the case, but was not 100% certain

I've learnt so much from the help, I have got on this site, more than from any Excel text book