=CONCATENATE

[j4ymf]

Hello

I was wondering how do i CONCATENATE in date format, ive tried this but i get an error

=CONCATENATE(TEXT(J8,”mm/dd/yyyy”,K8,TEXT(L8,”mm/dd/yyyy”)

 

[Peter_SSs]

Just checking: Does K8 have a date too, or some other type of value?

 

[j4ymf]

Good morning Peter, K8 is just a seperator " - "

thank you

 

[Peter_SSs]

Good morning Peter, K8 is just a seperator " - "

thank you

Edit: Oops, mixed up the date formats originally, corrected now

=CONCATENATE(TEXT(J8,"mm/dd/yyyy"),K8,TEXT(L8,"mm/dd/yyyy"))

.. or without the K8, build the separator into the date format

=TEXT(J8,"mm/dd/yyyy - ") & TEXT(L8,"mm/dd/yyyy")

 

[j4ymf]

Thank you so much Peter your a star

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.