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 don’t 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.