Calculate workdays in a month.

Y

YY san.

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
 
R

Ron Rosenfeld

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
Click to expand...


B2: =NETWORKDAYS(DATE($A$1,A2,1),DATE($A$1,A2+1,0))

and fill down to B13

--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the number of workday in a month 5
Calculate date so many days before/after current date. 4
Find the position of a date 6
weeks in a month 1
how to get "EndDate" of a project? 2
extracting only month from a date 6
automatic calculate at specific month 0
(month) 2 digits in formula 5

Top