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

.

Relevant Pages

  • Re: How to get number of working days
    ... Look into the WS function NETWORKDAYS. ... computing the number of working days and not just saturday and sunday. ... nougain's Profile: ...
    (microsoft.public.excel.programming)
  • Re: profile logon problem
    ... >First, I'm not new to Windows or computing in any way, but I recently ... >The thing I want to do is make it so that both the network user and local ... user of the same username share the same profile, directories, desktop, etc. ...
    (microsoft.public.win2000.security)
  • profile logon problem
    ... First, I'm not new to Windows or computing in any way, but I recently ... The thing I want to do is make it so that both the network user and local ... user of the same username share the same profile, directories, desktop, etc. ...
    (microsoft.public.win2000.security)
  • Re: Computing, Computer Weekly and IT Week
    ... I thought this was a bit odd as the company I work for is pretty firmly ... longer fit their profile! ... Like you I was told (by Computing) that I no longer 'fitted the profile' (1 ...
    (uk.comp.misc)
  • Calculate A Date Excluding Weekends And Holidays
    ... tasks can not include weekends or holidays. ... I have 10 business days to complete a task ... travelersway's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17623 ...
    (microsoft.public.excel.newusers)