PDA

View Full Version : Solved: Counting weekdays

slamet Harto
12-15-2010, 07:31 PM
Hi guys

12-15-2010, 07:39 PM
=NETWORKDAYS(A1,A2)

Where A1 and A2 are the start and end days

slamet Harto
12-15-2010, 09:01 PM

However, I want to counting the weekdays with public holidays.

12-15-2010, 09:03 PM
Then put the dates of the public holidays in as a parameter:

1/01/2010

10/01/2010

5

=NETWORKDAYS(G12,G13,"6/1/2010")

slamet Harto
12-15-2010, 09:11 PM
Yes I did. please take a look on the above attachment.

Its courious some of formula is doesn't work. Pls advice

12-15-2010, 10:34 PM
The immediate issue I see is the dates you listed as public holidays, you have the 24th and 25th Dec 2010 but the 24th is a work day and the 25th is a Saturday, the correct public holidays (at least in Aus, not sure about elsewhere) are the 27th and 28th

slamet Harto
12-15-2010, 11:42 PM
Hi Dan

I don't thing so, 24 & 25 are public holidays in here.
Can you advise, why my formula at J43, J48 and J49 doesn't work.

Thanks so much

slamet Harto
12-16-2010, 12:50 AM
Hi Dan

Thanks for assistance.
I end up with reformat the dates.

Once again thank you and have a nice day

Bob Phillips
12-16-2010, 12:56 AM
Try

=LOOKUP(2,1/A2:H2,A2:H2)

in J2 and copy down

slamet Harto
12-16-2010, 09:30 AM
Thanks bob for amazing solution. Its like magic for me.

Eventhought, I don't know how to figure out your formula.