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.

"Elkar" wrote:

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


"lschuh" wrote:

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.