Number of workdays in a month

[Nigel Bennett]

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

 

[Tom Ogilvy]

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

 

[Ron Rosenfeld]

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