From: mars on 13 May 2010 16:40 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
First
|
Prev
|
Pages: 1 2 Prev: VLOOKUP formula displays in cell, will not return data Next: date check with exchange rate |