View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
YY san.[_2_] YY san.[_2_] is offline
external usenet poster
 
Posts: 27
Default Count the number of workday in a month

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.