I am looking for some advice on how to do the following

A user will enter a date in Cell A1

I want excel to calculate the workdays that that
represents for the month

ie he puts in 1 Jan the result will be 0

he puts in Jan 15 the result would be 10 etc
Thanks

Nigel

Look in Excel help at the Networkdays function from the analysis toolpack

Demo'd from the immediate window:

? application.Run( "ATPVBAEN.XLA!NetWorkDays","01/01/2005","01/15/2005")
10



--
Regards,
Tom Ogilvy

"Nigel Bennett" wrote in message
...
I am looking for some advice on how to do the following

A user will enter a date in Cell A1

I want excel to calculate the workdays that that
represents for the month

ie he puts in 1 Jan the result will be 0

he puts in Jan 15 the result would be 10 etc
Thanks

Nigel

On Tue, 1 Mar 2005 19:41:34 -0800, "Nigel Bennett" wrote:

I am looking for some advice on how to do the following

A user will enter a date in Cell A1

I want excel to calculate the workdays that that
represents for the month

ie he puts in 1 Jan the result will be 0

he puts in Jan 15 the result would be 10 etc
Thanks

Nigel

=networkdays(A1-DAY(A1)+1,A1,Holidays)

Holidays is a range in which you have entered the dates of Holidays. It is
optional.

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

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