i'm short for long formulas, can anyone help me with this.

assuming i have a 20 dates in text format (e.g. "25 DEC", "01 JAN", "01
MAY", etc..) in column X which contains the standard public holidays.
(x1:x20). i made it to 20 yet some cells are blank for any future additions)

and in column A, i have a series of dates for say 6 years, starting from
01/01/2006 down to 12/31/2012

Then, I need to collect the real dates of standard public holidays in column
A (e.g. 01/01/2006,01/01/2007,etc) and place them all in Column C, under a
defined name "holidays"..

surely someone knew this a since long time ago.

any suggestion is welcome.

driller