Hi there hope someone can help, here goes

Date RM MR

05/08/1997 £13.64 £53.41
04/05/1998 £62.94 £246.44

i am looking for a formula to check which date is the oldest and put in the
corresponding amounts

ie as above 05/08/97 is oldest date therefore A10= £13.64 A11= £53.41 and
B10=£62.94 B11=£246.44

hope this makes sense!!!!!!!!!!!!!