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))

--
Biff
Microsoft Excel MVP


"YY san." wrote in message
...
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.

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


"T. Valko" wrote:

Try this...

Entered in B2 and copied down to B13:

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

--
Biff
Microsoft Excel MVP


"YY san." wrote in message
...
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.



.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"YY san." wrote in message
...
Hi guys,
Thank you very much for your prompt reply.
Have a nice day.


"T. Valko" wrote:

Try this...

Entered in B2 and copied down to B13:

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

--
Biff
Microsoft Excel MVP


"YY san." wrote in message
...
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.



.

=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 ToolsAddIns

If this post helps click Yes
---------------
Jacob Skaria


"YY san." wrote:

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.

-----------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
---------------
Jacob Skaria


"Jacob Skaria" wrote:

=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 ToolsAddIns

If this post helps click Yes
---------------
Jacob Skaria


"YY san." wrote:

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.