Count the number of workday in a month

[YY san.]

Hi,
Pardon me if I have already posted this question, because I cant locate my
question anywhere. I guess, it is not saved.

I know I need to use NETWORKDAYS, but don't know how.
Cell A1 stores 2009
Cell A2 ~ A13 stores 1 ~ 12, representing months.
Above value are format as numbers.
I need a formula in cell B2 to result 22, B3 = 20, ie. the number of
workdays in that month. Appreciate if anyone coudl provide me with the the
formula.
Thanks so much.

 

[T. Valko]

Try this...

Entered in B2 and copied down to B13:

=NETWORKDAYS(DATE(A$1,A2,1),DATE(A$1,A2+1,0))

 

[Jacob Skaria]

=NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,0))

In case you are using 2003; make sure you have installed Analysis
ToolPak..From Tools>AddIns>

If this post helps click Yes

 

[Jacob Skaria]

-----------Refer help on NETWORKDAYS ...if you want to add a holiday list.

Syntax:
=NETWORKDAYS(start_date,end_date,holidays)

Holidays is an optional range of one or more dates to exclude from the
working calendar, such as state and federal holidays and floating holidays.
The list can be either a range of cells that contains the dates or an array
constant (array: Used to build single formulas that produce multiple results
or that operate on a group of arguments that are arranged in rows and
columns. An array range shares a common formula; an array constant is a group
of constants used as an argument.) of the serial numbers that represent the
dates.

--------Alternative solution without considering a holiday list and without
using the ATP function

=SUM(INT((WEEKDAY(DATE($A$1,A2,1)-{1,2,3,4,5},2)+DATE($A$1,A2+1,0)-DATE($A$1,A2,1))/7))


If this post helps click Yes

 

[YY san.]

Hi guys,
Thank you very much for your prompt reply.
Have a nice day.

 

[T. Valko]

You're welcome. Thanks for the feedback!