I'm an 2002 user
but this function does not work in my excel
after using excel gives me function error
And I want to determine that ; I tried your given function also before and
after you advice me
thank you


"Ron Rosenfeld" wrote:

On Wed, 8 Aug 2007 05:36:02 -0700, onur wrote:

How can I count the working day between two date,exlude saturday sunday and
30.08.2007.

The notice is there may be too many dates in two date coloumn and at some
rows 2nd. dates may not pass 30.08.2007

help me

thank you

Use the NETWORKDAYS function. List 30.08.2007 as a Holiday.

e.g.

A1: 12 Jul 2007
B1: 15 Aug 2007
I1: 30 Aug 2007

=NETWORKDAYS(A1,B1,$I$1) -- 25
--ron