Sorry, yes, I guess it is an add-in but a standard one. This is from
the Help for my Excel 97 which is from the Office 97 Pro version.
Returns the number of whole working days between start_date and
end_date. Working days exclude weekends and any dates identified in
holidays. Use NETWORKDAYS to calculate employee benefits that accrue
based on the number of days worked during a specific term.
If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must
enable it by using the Add-Ins command on the Tools menu.
Syntax
NETWORKDAYS(start_date,end_date,holidays)
Start_date is a date that represents the start date.
End_date is a date that represents the end date.
Holidays is an optional range of one or more dates to exclude from the
working calendar, such as state and federal holidays and floating
holidays.
Remark
If any argument is not a valid date, NETWORKDAYS returns the #NUM! error
value.
Example
NETWORKDAYS(DATEVALUE("10/01/91"), DATEVALUE("12/01/91"),
DATEVALUE("11/28/91")) equals 43
----- Original Message -----
From: Jim Meagher <[log in to unmask]>
To: PCSOFT - Personal Computer software discussion list
<[log in to unmask]>
Cc: <[log in to unmask]>
Sent: Saturday, June 10, 2000 1:39 PM
Subject: Re: Re: [PCSOFT] Excel Date Calculations
> There is no such function in my Exel 97.
> Can you provide a more detailed answer?
> Is this an add-in?
> Where did you get it?
> How does it work?
> Etc....
>
> Jim Meagher
>
> ----- Original Message -----
> From: "Earl Truss" <[log in to unmask]>
>
> > Sounds like you want the NETWORKDAYS function.
> >
> > ----- Original Message -----
> > From: Jim Meagher <[log in to unmask]>
> >
> >
> > > In Excel 97, I need to compute the number
> > > of weekdays (Mon-Fri) between two given dates.
> > > Like so:
> > >
> > > Start End Number
> > > Date Date of Weekdays
> > > 1/1/00 1/16/00 10
> > > 6/7/00 6/11/00 3
> > >
"Hold No Punches.." Rode brings you great shareware/freeware
programs with his honest opinions in this weekly column.
http://nospin.com/rode
|