1.

=NETWORKDAYS(Start_date,End_date,Holidays)

with start date in A1 and end in B1 and holidays in H1:H11


=NETWORKDAYS(A1,B1,H1:H11)

2.

Select the range with the number of days

do formatconditional formatting, select cell value is greater than
put 20 in the value box


--

Regards,

Peo Sjoblom

"Pete" wrote in message
...
That's perfect thanks! My next question (hopefully my last) relates to the
addition to two further columns.

The two columns we discussed refer to the date a request was received(A1)
and the target date (+20 days) by which we should respond(A2). A third
column
will then log the date we actually responded(A3)...

I would like a fourth column to log the number of working days between the
date the request was received(A1) and our actual response date(A3). I
can't
work out how to integrate WORKDAYS into a simple '=A3-A1' formula.

Also, to further complicate things, how would I get a value greater that
20
(ie a late response) to show up in red?

Thanks again for your help.

Pete