Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
4 and 5 week months | Excel Discussion (Misc queries) | |||
Calculate running target by days in the month | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) | |||
Calculating Working Days | Excel Worksheet Functions | |||
Is there a way to calculate business working days between dates i. | Excel Worksheet Functions |