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.
--
iwgunter
------------------------------------------------------------------------
iwgunter's Profile:
http://www.excelforum.com/member.php...o&userid=15441
View this thread:
http://www.excelforum.com/showthread...hreadid=276213