Thanks David - tried that one - it changes the cell to "Open Call" for some
reason?

"David Biddulph" wrote:

Have you looked at NETWORKDAYS(), rather than DAYS360() ?
--
David Biddulph

"Andy B" wrote in message
...
I am trying to calculate the difference between one cell and another - both
having dates in, to establish if a service level is being achieved for
completing a task.

eg. B2 = 25/6/07 and L2 = 30/6/07 (5 days)

currently if there is no date in L2, it will say "open call" - indicating
that it has not been completed.

the calculation used currently is =IF(ISERROR(DAYS360(B2,L2,TRUE)),"Open
Call",DAYS360(B2,L2,TRUE)) however this does not show working days taken
to
complete the call, which is key to the measurement.

Can anybody help please?