Re: How to get number of working days

nougain,
Look into the WS function NETWORKDAYS.

NickHK

"nougain" <nougain.2432kz_1141371902.3213@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:nougain.2432kz_1141371902.3213@xxxxxxxxxxxxxxxxxxxxxxxx

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?action=getinfo&userid=32031
View this thread: http://www.excelforum.com/showthread.php?threadid=518584



.

Relevant Pages

  • How to get number of working days
    ... 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. ... nougain's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32031 ...
    (microsoft.public.excel.programming)
  • Hide data based on future date
    ... dates that are greater than TODAY, cell in second column should appear ... What I need to do in my VBA function such that it does ... nougain's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32031 ...
    (microsoft.public.excel.programming)