How do I glue cells together to get the date? Have tried concatenate!

[Katman]

Hi

I have this little problem I hope someone can help me with.

I have these three different dates, that I chose from lists (made in data-validation). I need to make them into normal excel-dates though, but somehow it does not work. I am guessing it has to do with the fancy conditions I have put on the lists?

If you look in cell sheet1!F10, where i try to get the date out, something goes wrong. It works for same dates, others it show the wrong date, and other again it says #N/A.

Please show me a way to get the correct dates out!

Thank you!

Jacob

[beaunydal]

You have left out the VLOOKUP function's 4th parameter, so try...
=CONCATENATE(C12,"-",VLOOKUP(C11,Sheet2!D3:G14,4,0),"-",C10)

Without the 4th parameter xl assumes that the values in Sheet2!D3:D14 are sorted in ascending order.
When it looks for February and then discovers that the first entry is January, which in a sorted list would come after February, it assumes that February is not available.

Beau Nydal

[martindwilson]

=DATEVALUE(CONCATENATE(C12,"-",VLOOKUP(C11,Sheet2!D3:G14,4,FALSE),"-",C10))
will give a real date

[Only4Excel]

Or,

=(C11&C12&", "&C10)+0