View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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