How to get number of working days

[nougain]

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.

[Norman Jones]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Carim]

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

[NickHK]

nougain,
Look into the WS function NETWORKDAYS.

NickHK

"nougain" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>