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.