concatenate with date

[normpam]

A1 B1 C1
01/02/2022 Inv 5210 =B1&" - "&A1 this formula will give me the value in B1 and the numeric equivalent of the date in A1. If I put an apostrophe in front of the date, I can get
Inv 5210 - 01/02/2022. Is there any other way to put the cells together without using the apostrophe? I tried formatting the dates in Column A
to Text, but didn't help......

 

[Peter_SSs]

Not sure if your date is d/m/y or m/d/y but adjust the date format in a formula like this.

22 02 02.xlsm
	A	B	C
1	1/02/2022	Inv 5210	Inv 5210 - 01/02/2022
concat date

Cell Formulas
Range	Formula
C1	C1	=B1&" - "&TEXT(A1,"dd/mm/yyyy")

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Edit: You could also avoid one concat by including the dash in the date format:

=B1&TEXT(A1," - dd/mm/yyyy")

 

[Rick Rothstein]

Assuming your date order is dd/mm/yyyy, then try this...

=B1&TEXT(A1," - dd/mm/yyyy")

 

[Peter_SSs]

Sorry Rick, you may have actually posted while I was adding my edit.

 

[normpam]

Assuming your date order is dd/mm/yyyy, then try this...

=B1&TEXT(A1," - dd/mm/yyyy")

Thanks much. Perfect. I forgot about the Text formula!