Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nigel
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Sukhjeet
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
4 and 5 week months Big Rick Excel Discussion (Misc queries) 15 November 7th 05 01:32 AM
Calculate running target by days in the month Robert Excel Worksheet Functions 2 July 4th 05 06:14 AM
Working time and days Nortos Excel Discussion (Misc queries) 1 May 6th 05 03:47 PM
Calculating Working Days will Excel Worksheet Functions 5 March 22nd 05 01:44 PM
Is there a way to calculate business working days between dates i. hjyoungii Excel Worksheet Functions 2 February 23rd 05 05:25 PM


All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"