Calculation of working days between two dates

A

Andy B

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.

have tried advice below, but unfortunately it still includes the weekend
days - can I
include the WEEKDAYS or NETWORKDAYS formula in this somehow? thanks
 
B

Bernie Deitrick

Andy,

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

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating a formula for a service level 6
converting working hours to days 2
days calculation between dates 10
Days between 2 dates excluding Sundays only 1
Number of days 2
Key Card Software (Auric) 7
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS 3
Subtracting two cell dates and highlight if over due by a certain amount of days 0

Top