Bob

i need a formulae similar to the one you gave me for downtime. i have an
estimate date and a date estimate was authorised, i want to know how long it
took from the date of estimate to the date it was authorised but i want the
weekends included. if authorised date not given o est date not given then
return as blank.

"Stuart" wrote:

I work for a company in Hertford now. We are an accident management company
as part of our services we provide our fleet customers with weekly, biweekly,
monthly or even daily reports. one of the pieces of information in these
reports is the downtime which is how long the vehicle has been in the
bodyshop. I have attached an working example to this to this email it uses an
excel formulae to calculate the difference between the 2 dates. now then what
I want to know from you is how to improve on this formulae.

I need it to not only work out the difference between the 2 dates but if a
onsit date is given but no returned date it will show how many days its been
from onsite date to today's date. also if returned date is given but no
onsite date it should return a blank value as our customers dont want to see
"#VALUE" show up anywhere. lastly this formulae is limited in that our
bodyshop's do not work on weekends yet the current formulae can't compensate
for weekends is the any way to get the formulae to filter out weekends when
doing its calculations?

any help you can provide me with would be greatly appreciated. thanks in
advance.