amount of working days per month

[Guest]

Hi,

is there a way of working out the amount of basic working days( Mon to Fri )
per month in a formula or VBA? i am trying to create a yearly summary for 10
men. this needs to work out the amount of actual working days per month
multiplied by hours to get an accurate amount of actual required working
hours per month.

help greatly appreciated.


Nigel

 

[Guest]

Hi NIgel
Use the formula NETWORKDAYS(date1, date2) to find out no of working days
between 2 months.
Regards
Sukhjeet

 

[Bob Phillips]

Hi Nigel,

=networkdays(A1-DAY(A1)+1,DATE(YEAR(A1),MONTH(A1)+1,0))

where A1 contains a date within the target month. NETWORKDAYS is part of the
Analysis Toolpak, so you will need to install that.

--

HTH

RP
(remove nothere from the email address if mailing direct)