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)


"Nigel" wrote in message
...
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