Custom Date in formula

[trosasco23]

Hello I need a simple formula fix.

IN MY CSV TO UPLOAD TAB - I have a column which I have to change the date in every week and I separated it into 3 columns to make it easier.

Column "T" I will always be TSWK.
Column "U" is a date that will change every week but I had to format it to a custom look: mm-dd-yyyy.
Column "V" will always be _SOLAR_HOURLY

In Column "S", I did a concatenate formula to put them all together like this TSWK08-20-2022_SOLAR_HOURLY

My formula is: =CONCATENATE(T2,U2,V2)

The only problem I'm having is that the date is coming up as a serial number 44793 and not the date as I custom set it.

[MrShorty]

That is where the TEXT() [https://support.microsoft.com/en-us/...8-93d29371225c ] function comes in handy. Replace the reference to U with TEXT(U...,"mm-dd-yyyy")

[HansDouwe]

Please try

Please Login or Register  to view this content.

[trosasco23]

Thank you Hans. Seemed easy enough.. You're awesome.