Hi Ron

Don't know what was going on with my previous replies getting screwed
up.
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())),"")

--
Regards

Roger Govier


"Ron Coderre" wrote in message
...
Thanks, Roger

and, very true about the date format....But, I had it in the back of
my mind
that the formula could easily be tweaked for non-US date formats.
Hopefully,
that holds true.

***********
Best Regards,
Ron

XL2002, WinXP