Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: Excel Date Calculations
From:	At Neethling <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Mon, 12 Jun 2000 12:30:20 +0200
Content-Type:	text/plain
Parts/Attachments:	text/plain (38 lines)

Jim

There is an Excel function called Networkdays that will do the trick.  The
syntax is:
     Networkdays(Start_date,End_date[,Hollidays])
Both dates have to be in date format.  The last (optional) item, Hollidays,
refers to a range of dates to be excluded in the calculation.  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.

At Neethling
Cape Town

>
>
>Date:    Fri, 9 Jun 2000 21:32:31 -0400
>From:    Jim Meagher <[log in to unmask]>
>Subject: Excel Date Calculations
>
>Good Morning to all....
>
>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
>
>Any and all suggestions will be appreciated.
>

             PCSOFT maintains many useful files for download
                     visit our download web page at:
                     http://nospin.com/pc/files.html

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG