calculating a formula for a service level
Thanks Mike - unfortunately it still includes the weekend days - can I
include the WEEKDAYS or NETWORKDAYS formula in this somehow? thanks
"Mike H" wrote:
Andy,
Try this:-
=IF(L2="","Open Call",L2-B2)
Format as general. It assumes L2 will always be a later date then B2 or blank.
Mike
"Andy B" wrote:
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?
|