Solved: Counting weekdays

[slamet Harto]

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]

=NETWORKDAYS(A1,A2)

Where A1 and A2 are the start and end days

[slamet Harto]

Thanks Dan, appreciate your help.

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

[Blade Hunter]

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]

Yes I did. please take a look on the above attachment.

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

[Blade Hunter]

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]

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]

Hi Dan

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

Once again thank you and have a nice day

[Bob Phillips]

Try

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

in J2 and copy down

[slamet Harto]

Thanks bob for amazing solution. Its like magic for me.

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