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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.