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