Don't know what was going on with my previous replies getting
screwed up.

Yeah, that was strange.

Yes is does work for UK, provided you switch the month and day around
=IF(A1,LOOKUP(365,((TEXT(A1,"d/m/")&YEAR(TODAY())+{0,1})-TODAY())),"")

Actually, it won't work properly as there is a flaw in it, and in ALL of the
other formulas as well... see either of my two latest postings for the
explanation.

Rick