Combine text & date1 & date2 into one single cell - end formatting problem - Excel 2007

[teh.format]

Hello!

I've got problem with combining 3 cells into one. First cell contains text, second have date yyyy-mm-dd and last one is as previous. I'm using formula

=Y1&"_"&Y2&"_"&Y3

and I'm getting: TEXT_41694_41701. How can that be corrected to use formatting for date format to get TEXT_yyyy-mm-dd_yyyy-mm-dd?

Thanks in advance!

[:) Sixthsense :)]

=Y1&"_"&TEXT(Y2,"yyyy-mm-dd")&"_"&TEXT(Y3,"yyyy-mm-dd")

[teh.format]

=Y1&"_"&TEXT(Y2,"yyyy-mm-dd")&"_"&TEXT(Y3,"yyyy-mm-dd")

I used this formula but I'm getting error (there is an error with formula).

Can you look into excel file and get this working? datewithtext.xlsx

Thanks again!

[:) Sixthsense :)]

I adapted the formula to your attachment file. Please check and confirm

=A2&"_"&TEXT(A3,"yyyy-mm-dd")&"_"&TEXT(A4,"yyyy-mm-dd")

[teh.format]

I translated TEXT into polish function but still getting same error about formula. Can you paste your formula to attachment and attach it to your post? Ty!

[:) Sixthsense :)]

I think this yyyy-mm-dd also needs to be converted to polish version.

Please check the attachment.

[notinuse]

Thanks for posting this!