Business days count

[Benoit]

Hello

If I have in cells:

A B C
=============== =============== ===============
1) 03/01/2004 0:00 03/08/2004 0:00
2) 03/01/2004 0:00 03/10/2004 0:00
3) 03/01/2004 0:00 03/07/2004 0:00
4) 03/01/2004 0:00 03/17/2004 0:00

I want to have a formula that will count the days
difference between A and B taking in consideration the
business days...

Thanks!!!

 

[Frank Kabel]

Hi
try
=NETWORKDAYS(A1,B1)

 

[Charlie]

Try

=NETWORKDAYS(A1,B1)
and copy down. Also see Networkdays in the help menu for
more options.

Charlie O'Neill

 

[Bob Phillips]

=NETWORKDAYS(B1,A1)

you can also create a holiday list and ignore those

=NETWORKDAYS(B1,A1,H1:H10)

make sure tha Analysis Toolpak is installed

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)