LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
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 12: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 12:44 PM
Is there a way to calculate business working days between dates i. hjyoungii Excel Worksheet Functions 2 February 23rd 05 04:25 PM


All times are GMT +1. The time now is 02:44 AM.

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

About Us

"It's about Microsoft Excel"