CONCATENATE date format

[JasAujla]

Hi All,

I have a CONCATENATE formula in Col K but I need it to keep the date format in column E (yyyy/mm/dd) without having to change Column E format to TEXT

Currently showing as 43851

Any help please?

 

[JasAujla]

Hi All,

I have a CONCATENATE formula in Col K but I need it to keep the date format in column E (yyyy/mm/dd) without having to change Column E format to TEXT

Currently showing as 43851

Any help please?

View attachment 30435

 

[JasAujla]

Current formula as below:

 

[jasonb75]

You will need to use the TEXT function in the formula, change E6 to

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

If your system language is not English then you might need to translate "yyyy/mm/dd" to match your settings.

 

[JasAujla]

You will need to use the TEXT function in the formula, change E6 to

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

If your system language is not English then you might need to translate "yyyy/mm/dd" to match your settings.

You will need to use the TEXT function in the formula, change E6 to

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

If your system language is not English then you might need to translate "yyyy/mm/dd" to match your settings.

Thanks how can I incorporate that formula into my cureent formuka?

 

[Fluff]

As you have 365, you could use

=TEXTJOIN("|",0,A6:D6,TEXT(E6,"yyyy/mm/dd"),F6:J6)

 

[JasAujla]

Sorted it thanks

 

[JasAujla]

Sorted it thanks

As you have 365, you could use

=TEXTJOIN("|",0,A6:D6,TEXT(E6,"yyyy/mm/dd"),F6:J6)

So much easier than CONCATENATE thank you

 

[Fluff]

Glad we could help & thanks for the feedback