Weekdays calculation

[DJPants]

Hello,
Does anyone know how to calculate the number of weekdays in a given month and year?

eg October 2006 = 22
December 2006 = 21 etc.

Many thanks,

 

[DiscoPistol]

Hi,

=NETWORKDAYS(39356,39385)

Will give you the number of days.

The numbers represent Serial Date in Excel (Which I think is the number of days since 1/1/1900)

Hope that helps

DP

 

[arthurbr]

The networkdays function will need installation of the analysis toolpak add-in I think

HTH

 

[DiscoPistol]

I should mention that you can also add Holidays (Bank Hols etc) using this Formula

 

[ADAMC]

NETWORKDAYS Returns the number of whole workdays between two dates.
NETWORKDAYS(start_date,end_date,holidays)
NETWORKDAYS("10/01/1998","12/01/1998","11/26/1998")
Or
NETWORKDAYS(start_date,end_date)

 

[barry houdini]

If you have the 1st day of the month, e.g. 1-OCT-2006, in A1 then, using Analysis ToolPak functions

=NETWORKDAYS(A1,EOMONTH(A1,0))

or without Analysis ToolPak

=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+DAY(DATE(YEAR(A1),MONTH(A1)+1,-1)))/7))