amount of working days per month
 

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

amount of working days per month
 

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

"Nigel" wrote:

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

amount of working days per month
 

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