Struggling with =IF(K7-J7<=1,"",J7+1)
Thanks Bob. it still returns a blank rather than the expected date
02/04/2007? Dan
"Bob Phillips" wrote:
=IF(OR(K7="",J7="",K7-J7<=1),"",J7+1)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"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
|