Re: How to get number of working days

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <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

  • Re: List of functions contained in the add-ins, esp. Analysis Toolpak
    ... "Neil Goldwasser" ... add-ins, especially the Analysis Toolpak and VBA Analysis Toolpak. ... looked in Excel help and have found a list of functions by category, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do I calculate dates and times, w/answer of days & hours
    ... Are you sure that DateDif needs Analysis ToolPak, ... It isn't explained in Excel help, ... Also there's no DateIf function. ... Analysis Toolpak addin, which may be what you are looking for. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Auto Fill Weekdays Only
    ... the function is WORKDAY rather than WORKDAYS. ... See Excel help for details. ... "Tom Ogilvy" wrote in message ... If 10 days did land on a weekend then it would just get bumped to ...
    (microsoft.public.excel.programming)
  • Re: Yield fomula error #Name?
    ... and load the Analysis ToolPak add-in." ... Amazing stuff can be found when using Excel Help. ...
    (microsoft.public.excel.misc)
  • Re: how do i know date after no. of working days
    ... You need to install the Analysis ToolPak for this to work if you are ... using Excel 2003 or earlier - see Excel Help for further details. ... Suppose if we consider today's date i have to get date after 12 wrkng days. ...
    (microsoft.public.excel.worksheet.functions)