Thanks a lot to both of you. it worked!

"Dave O" wrote:

With your yyyy-mm-dd date in Excel-readable format in cell A1, this
formula will do it:
=YEAR(A1)&A1-DATE(YEAR(A1),1,1)