Thanks Ron. I'm sure this would work fine, but unfortunately I need to get
this working on a Quattro Pro spreadsheet. I was hoping for a formula I
could amend to suit and without having to install addins.

Rob

"Ron Rosenfeld" wrote in message
...
On Mon, 20 Dec 2004 10:56:15 +1030, "Rob" wrote:

Hi group,

Is there a formula that can extract the number of weekends between 2
variable dates?

Rob


If you have the Analysis Tool Pak installed, then:

=(A2-A1-networkdays(A1,A2)+1)/2

============================
If the NETWORKDAYS function is not available, and returns the #NAME?
error,
install and load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then
click
OK.
If necessary, follow the instructions in the setup program.

--ron