there's a function in the Analysis Toolpak for this
called NetWorkdays.

Activate the addin.
and see Excel help.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


iwgunter wrote in message
:


I have created a worksheet to see how long it takes our suppliers to get
back with quotes.

I have had to add a sheet called DateNumber where every working day has
a number associated, as I don't want weekends to be part of the
equation:


Code:
--------------------
Fri 05/11/2004 216
Mon 08/11/2004 217
Tue 09/11/2004 218
Wed 10/11/2004 219
Thu 11/11/2004 220
Fri 12/11/2004 221
Mon 15/11/2004 222
Tue 16/11/2004 223
--------------------


Is there a VB script for this, rather than me making a neverending
worksheet?

ALSO...

Some areas don't have dates, so I get a #N/A showing up. This messes up
the average sums I have set up on another sheet. Can I get around this
with an IF/ELSE statement.