Dislpay count of workdays in a month?
 

I have an excel sheet with the month and year in the A row..Like

Jan-06 Feb-06 Mar-06 Apr-06

How do i insert a formula in B row, to display the number of weekdays
in that corresponding month, like this?

Jan-06 Feb-06 Mar-06 Apr-06
22 20 23 20

Please advise

Cheers
Sunny

Dislpay count of workdays in a month?
 

Here's one way....

assume that your your row 1 contains dates - the first day of each
month - formatted as mmm-yy, with Jan-06 in A1

in A2 use this formula

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

formatted as general, copied across row.

Note both NETWORKDAYS and EOMONTH are part of Analysis ToolPak add-in.
An alternative formula which doesn't require Analysis ToolPak

=32-DAY(A1+31)-SUM(INT((WEEKDAY(A1-{0,1})+31-DAY(A1+31))/7))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=524821

Dislpay count of workdays in a month?
 

Make sure you have the Analysis Toolpak isntalled (Tools-Add-ins.. and make
sure the Analysis Toolpak is checked), then use the formula

=networkdays(--"1/1/2006",--"2/1/2006")

If A1 & B1 contain the dates Jan 1 & Feb 1 of 2006, use

=networkdays(A1,B1)



"DB Explorer" wrote:

I have an excel sheet with the month and year in the A row..Like

Jan-06 Feb-06 Mar-06 Apr-06

How do i insert a formula in B row, to display the number of weekdays
in that corresponding month, like this?

Jan-06 Feb-06 Mar-06 Apr-06
22 20 23 20

Please advise

Cheers
Sunny