concantenate text to date

L

lschuh

I have 3 columns e2 month f2 day g2 year 5/15/7
How can I concantenate column e2+f2+g2 to get 5/15/07

thanks.
 
E

Elkar

Do you want the result to be a date? Or text that looks like a date?

To get a date:

=DATE(G2,E2,F2)

To get text:

=TEXT(DATE(G2,E2,F2),"m/d/yy")

HTH,
Elkar
 
K

Kevin B

You can join each value by using the & to concatenate the text:

=E2&"/"&F2&"/"&G2

or if you want you can do the following:

=DATE(G2,E2,F2)

And then format the for the date format of your choice.
 
L

lschuh

the =text(date(xxxxx) worked. The first one just gave me what I typed in.
Probably the format in the cell was off. Thank you so much.
 
Top