Display a date from one column into a text column of another

MSGFreebird

I have a sheet that I have one column that is a date column. I need that date to be populated into another column cell that is text format. How can I accomplish this? Currently When a date is inputted the corresponding column show the following.

The formula used is this.

Any help would be appreciated.

Paul Newcome

Try this:

=INDEX([PS-Meta]:[PS-Meta], 1) + ""

Shanky Paul

Hi

You can try the below formula:

=[PS-Meta]@row + ""

Thank you!

MSGFreebird

@Shanky Paul

Thanks but the result is a blank cell.

Shanky Paul

It worked for me. Can you make sure there is a date in your "PS-Meta" column?

Paul Newcome

You just need to "add double quotes" to whatever you are currently using for your cell reference. If the cell you are referencing is in a different row from the cell you are wanting to contain this text version of a date, you would replace the "@row" portion with the appropriate row number.

=Column Name]@row + ""

=[Column Name]1 + ""

MSGFreebird

@Paul Newcome

Thanks Paul, that almost gets me there. So the information is populated into the sheet by a form. When the form adds a row at the top the formula now changes to =[PS-Meta]2 + "". The date added to the new first row will be the only date in the entire column. I tried just =[PS-Meta] + "" but that comes back as unparseable.

Thoughts?

Paul Newcome

Try this:

=INDEX([PS-Meta]:[PS-Meta], 1) + ""

MSGFreebird

@Paul Newcome

Thanks Paul that did it. I was so close with my first formula.

Paul Newcome

Happy to help. 👍️