Number of workdays in a month

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" <nigelben@yahoo.com> wrote in message
news:327101c51ed9$bac97ab0$a601280a@phx.gbl...
> 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" <nigelben@yahoo.com> 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