Thread: Calculate workdays in a month.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
YY san.[_2_] YY san.[_2_] is offline
external usenet poster
  
Posts: 27
Default Calculate workdays in a month.
Hi,
I have in A1, 2009 and A2~A13, numbers 1 ~ 12 representing Jan ~ Dec. This
is format as numbers, not date format. How can I use NETWORKDAYS in B2 to
produce 22, B3,20, ie. the no. of workdays in that month.

Appreciate your help.
Cheers,
YY

Reply With QuoteReply With Quote