Thread: Calculate workdays in a month.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu[_3_] muddan madhu[_3_] is offline
external usenet poster
  
Posts: 15
Default Calculate workdays in a month.
=NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,)-1)

"YY san." wrote:

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