[Michell Major]

There are several strings to this question.

1) =IF(C3="",TODAY()-B3),C3-B3. This is meant to calculate the elapsed time
between C3 and today if B3 is blank - but doesn't.

2) The formulae work OK except they return FALSE when cell N78 (DVLA cell)
has anything other than DVLA.
Option 1: =IF(AND(AD78="80",N78="Scrap/AV",""),AD78="DVLA",$AE$2)
Option 2:=IF(N77="","",IF(AD77=80,"",IF(AND(N77="DVLA",AD 77=""),$AE$2)))

3) Invoices are raised every month for vehicles kept in store. Two things;
I need to a) carry-over to a new worksheet, vehicles that remain unclaimed
and in store. and b) reset the clock to accumulate the next months' storage
charge.

Finally. When this has all been piloted for a month or twoI want to migrate
it to MS ACCESS so that data can be kept clean. Does anyone know whether the
Excel calculations migrate to Access?