Count the number of workday in a month

  • Thread starter Thread starter YY san.
  • Start date Start date
Y

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.
 
Try this...

Entered in B2 and copied down to B13:

=NETWORKDAYS(DATE(A$1,A2,1),DATE(A$1,A2+1,0))
 
=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
 
-----------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
 
Back
Top