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

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

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

Calculate workdays in a month.
 

sorry

=NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,))

"muddan madhu" wrote:

=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

Calculate workdays in a month.
 

sorry

=NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,))

"muddan madhu" wrote:

=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