On Wed, 19 Oct 2005 20:35:59 +0100, A strange species called Roger
Govier wrote:

Hi John

No need to enter -TODAY() in a cell, just use it in the formula. With your
next Birthday in cell A1, in B1 enter
=IF(A1=TODAY(),A1-TODAY(),"Birthday has passed")

Roger.

Yep. I think that one seems to do it. Thanks!

With regard to litres per 100 km converted to miles per gallon

1 gallon = 4.546 litres
1 mile = 1.6093 km or 1 km = 0.6214 miles 100 km = 62.14

=62.14/(A2/4.546)
or for your example of 7 litres/100km = 40.36 mpg

This is great too. I've formatted it to one decimal place and it's
looking pretty spot on. Cheers.

John