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

How to get number of working days
 

Hi Nougain,

See the Workdays and NetWoirkdays functions in Excel Help.

As Help explains, the functions are part of the Analysis ToolPak.


---
Regards,
Norman


"nougain" wrote in
message ...

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

How to get number of working days
 

Hi Nougain,

In addition to Networkdays in the Analysis Tool Pack, take a look at
all the solutions provided by Chip ...

http://www.cpearson.com/excel/DateTimeWS.htm


HTH
Cheers
Carim

How to get number of working days
 

nougain,
Look into the WS function NETWORKDAYS.

NickHK

"nougain" wrote in
message ...

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