Calculate workdays in a month.
On Tue, 27 Oct 2009 08:45:01 -0700, 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
B2: =NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,0))
and fill down to B13
--ron
|