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