Hi Dan

DVLA still struggling to charge us these fines??

Not sure what you are really asking, as there is insufficient
information
=IF(J23="","",IF(J23-K23<1,$P$2,""))

Unless the claim date is the same as the receive date, then it will
never be less than 1
Maybe you need the formula to be
=IF(J23="","",IF(J23-K23<=1,$P$2,""))
and the other one
=IF(M23="","",IF(M231,$Q$2))

However, you are also saying
The formula should recognise the received date and, if more than a day
has elapsed between K7 and J7, add
a day (02/04/2007 in L7)

You don't say what is in M7. Presumably something like
=IF(K7="",TODAY()-L7,K7-L7)
Is L7 an entered date or a calculated value?
Maybe L7 should be
=IF(K7="",J7+1,J7)

Just guessing, as there is not enough info.
--
Regards

Roger Govier


"Michell Major" wrote in
message ...
K7 = Date received
J7 = Date claimed
L7 = Storage start date
M7 = Elapsed days
N = Storage
O = Surety
P = Fine 1 (i.e. claimed within 24 hours)
Q = Fine 2 i.e. claimed over 24 hours
There are other cells dependent on this group to work out costs.

The formula works fine for STORAGE start date, apart from when a date
is
entered in K7 (say 01/04/2007) and J7 is blank. The formula should
recognise
the received date and, if more than a day has elapsed between K7 and
J7, add
a day (02/04/2007 in L7)

=IF(J23="","",IF(J23-K23<1,$P$2,"")) should not display the P value if
not
claimed within 24 hours.

=IF(M23="","",IF(M23=1,$Q$2)) works OK for the Fine 2 (Q) value.

Help with all of this much appreciated.

Dan