Counting Weekdays
Posted by jon on November 17, 2001 7:01 AM
Is there a way to count the number of weekdays in a month?
Posted by Dank on November 17, 2001 7:57 AM
Yes there is. Make sure that you have the Analysis Toolpak addin installed. The function NETWORKDAYS returns the number of working days between two dates and it also allows you to specify any holidays.
Regards,
Daniel.
Posted by Aladin Akyurek on November 17, 2001 8:31 AM
Daniel --
It seems Jon wants to count Saurdays and Sundays in a given month, say, Nov-2001. If so,
=SUMPRODUCT((WEEKDAY(DATE(YEAR(A9),MONTH(A9),ROW(INDIRECT("1:"&DAY(DATE(YEAR(A9),MONTH(A9)+1,0))))))={1,7})+0)
would do just that.
Aladin
===========
Posted by jon on November 17, 2001 9:07 AM
Thank you both for the help...
jon
