Thanks - I've tried this but no joy.

Doesn't this function need an = rather than an IF?

Rgds,
Kierano

"Roger Govier" wrote:

Hi

I think it should be something like

=IF(O37="","Not Met",
IF(NETWORKDAYS(E37,O37)
LOOKUP(K37,{"High","Medium","Low"},{5,10,15}),"Not Met", "Met"))

If you wanted to include Holidays, either name a range containing the
holiday dates as holidays, or use the cell references where the dates
are held, in the Networkdays part of the formula
NETWORKDAYS(E37,O37,$Z$1:$Z$10)

--
Regards

Roger Govier


"Kierano" wrote in message
...
I am using the following formula to check whether a change has been
turned
around on time. The beginning of the formula checks whether the source
column
has data in it, and if it doesn't returns a "Not Met".

However, this does not take weekends into account. I somehow need to
factor
in something that will only calculate the working days. I think I
should be
using 'WORKDAY', but am unsure as to how to fit this into the formula:

=IF(O37="","Not Met",IF(O37-E37LOOKUP(K37,{"High"},{5}),"Not Met",
"Met"))

E is the date received; O is the date the change was dealt with. K is
the
priority e.g. high, medium or low.

Anyone got any ideas please?

Thanks.