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?

calculating a formula for a service level
 

On 1 Aug, 08:56, Andy B wrote:
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?- Hide quoted text -

- Show quoted text -

Try

=IF(L2="","Open Call",NETWORKDAYS(B2,L2))

Mike