PDA

View Full Version : Solved: Counting weekdays



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

please help me to count how many weekdays between start date to end date.

please find attached for your reference.

Many thanks in advance

Blade Hunter
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
Thanks Dan, appreciate your help.

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

Blade Hunter
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

Blade Hunter
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.