From: mars on
Thank you Bernd - your solution was ace too.
Can you (or Gord) indulge me one more time please?
If I enter the year as before 2007/08 into A1 I would like the formula
in C2 to read 01/01/2008 (always showing January of the latter year.
Is this possible?

Kind Regards

Mars