How can I count the working day
 

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

How can I count the working day
 

Try this out, worked for my little test
=WORKDAY(B1,0)-WORKDAY(A1,0)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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

How can I count the working day
 

Cancel that, it did days not work days....I'll be back!
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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

How can I count the working day
 

I want to count like that
A B C
12/07/07 15/08/07 total working days(exlude sat. sun. and
30/08/07)
15/07/07 04/09/07 total working days(exclude sat. sun. and
30/08/07)
"John Bundy" wrote:

Cancel that, it did days not work days....I'll be back!
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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

How can I count the working day
 

Look at NETWORKDAYS function (Excel HELP)

"onur" wrote:

I want to count like that
A B C
12/07/07 15/08/07 total working days(exlude sat. sun. and
30/08/07)
15/07/07 04/09/07 total working days(exclude sat. sun. and
30/08/07)
"John Bundy" wrote:

Cancel that, it did days not work days....I'll be back!
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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

How can I count the working day
 

I tried but I havent find a solution as I want.
In my opinion It will be solute with a function but I havent find it.

"Toppers" wrote:

Look at NETWORKDAYS function (Excel HELP)

"onur" wrote:

I want to count like that
A B C
12/07/07 15/08/07 total working days(exlude sat. sun. and
30/08/07)
15/07/07 04/09/07 total working days(exclude sat. sun. and
30/08/07)
"John Bundy" wrote:

Cancel that, it did days not work days....I'll be back!
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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

How can I count the working day
 

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

How can I count the working day
 

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

How can I count the working day
 

What error message did you get? Did you look at what Excel help tells you
about the NETWORKDAYS function?
--
David Biddulph

"onur" wrote in message
...
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

How can I count the working day
 

"the formula you typed containss an error"

"David Biddulph" wrote:

What error message did you get? Did you look at what Excel help tells you
about the NETWORKDAYS function?
--
David Biddulph

"onur" wrote in message
...
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

How can I count the working day
 

So what was the formula that gave that error? Copy from the formula bar to
here.
--
David Biddulph

"onur" wrote in message
...
"the formula you typed containss an error"

"David Biddulph" wrote:

What error message did you get? Did you look at what Excel help tells
you
about the NETWORKDAYS function?

"onur" wrote in message
...
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

"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

How can I count the working day
 

On Thu, 9 Aug 2007 07:06:05 -0700, onur wrote:

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

The function works properly in XL2002.

What is the exact formula you used?
What was the text of the error message?
If you used cell references in your formula, what is the contents of the cells
to which you referred?


--ron