Keep date in a concatenate

[darcya]

Hi. I have two columns I'm concatenating, the second one being a date. How can I get my concatenate to recognize it as a date and not convert it to a number? Thanks.

 

[NeonRedSharpie]

Instead of using the cell reference O13 in your concatenate...use:

TEXT(O13,"mm/dd/yyyy")

 

[darcya]

Thanks. But is there a way to pick up more than one cell with this? My formula currently reads "=concatenate(f3,i3)", where f3 is a name, and i3 is a date.

 

[darcya]

I apologize - I went right to the formula without reading your instructions first. Worked like a charm!! Thank you!