date format with concatenate formula

[biglb79]

is there a way to have the date read like a normal date when using this formula instead of having to go to the invoice date cell and do this '12/31/20 before every date? right now a 2/27/21 date comes through as 44254, but if i put the parentheses in front of the date it comes through as 2/27/21

 

[Marcílio_Lobão]

bigllb79, Good morning.

To format all date cells as DATE is an option for you?

or

You can use too: ="The date is " & TEXT(A1;"dd/mm/aaaa")


Please, tell us if it worked for you.

I hope it helps.

 

[biglb79]

bigllb79, Good morning.

To format all date cells as DATE is an option for you?

or

You can use too: ="The date is " & TEXT(A1;"dd/mm/aaaa")


Please, tell us if it worked for you.

I hope it helps.

the dates were formatted as date, but this formula works if I add a new column and create the date in that column. thanks!

I didn't know how to change the concatenate formula I have of ($d$14,$e$14,j15) where j15 was the date

 

[Marcílio_Lobão]

biglb79, Good afternoon.

You're welcome & Thanks for the feedback.

Glad to help you.

 

[jtakw]

the dates were formatted as date, but this formula works if I add a new column and create the date in that column. thanks!

I didn't know how to change the concatenate formula I have of ($d$14,$e$14,j15) where j15 was the date

Hi,

Rather than creating a new column just for the Date conversion, why not do it directly within your Concatenate, something like:

=CONCATENATE($D$14,$E$14,TEXT(J15,"dd/mm/yyyy"))