In Column "T" I have in text format dates in the following format dd mmm
yyyy. Reason for text format, I sometimes do not have the year. Is it
possible to write a formula in column "V" that if row "XX" and column "T"
are not blank and number of characters are greater than six, the right four
numbers are subtracted from the current year, providing a number of years
value. Or would this require a macro?

--

Regards
Michael Koerner