LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to get number of working days


I have two dates (start and end). I want to know how many working days
are there between these two dates (both inclusive). If there is a ready
function in Excel, I would like to know that.

Also I have list of holidays that I would want to process while
computing the number of working days and not just saturday and sunday.
How I can do this. Thanks.


--
nougain
------------------------------------------------------------------------
nougain's Profile: http://www.excelforum.com/member.php...o&userid=32031
View this thread: http://www.excelforum.com/showthread...hreadid=518584

 
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
number or working days Gibbyky2 Excel Worksheet Functions 6 August 22nd 09 12:03 PM
Making weekend days working days - the system cuts the working tim Fluffy Excel Discussion (Misc queries) 1 May 30th 08 10:02 PM
Number of working days between 2 dates [email protected] Excel Discussion (Misc queries) 1 May 15th 07 06:02 PM
Subtract number of Working Days Casey Excel Worksheet Functions 2 August 19th 05 05:37 PM
calculate number of working days philc Excel Worksheet Functions 2 June 1st 05 07:48 AM


All times are GMT +1. The time now is 10:35 AM.

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"