Text With a Date Calculation in Cell?

[jdpro]

Greetings!
I would like to calculate a date in a cell with text. What I have tried has not worked, because the date calculation returns the number rather than the date.
I4 has a date entered. If I subtract 60 from I4, I can get a date result. But if I would like to add some text, the date result is the date number rather than the formatted date.
In L6 I put: ="60 DTE: "&I4-60
which results in
60 DTE: 45647.
Is it possible to get the result to format for the date?

Thank you very much!

 

[HighAndWilder]

Greetings!
I would like to calculate a date in a cell with text. What I have tried has not worked, because the date calculation returns the number rather than the date.
I4 has a date entered. If I subtract 60 from I4, I can get a date result. But if I would like to add some text, the date result is the date number rather than the formatted date.
In L6 I put: ="60 DTE: "&I4-60
which results in
60 DTE: 45647.
Is it possible to get the result to format for the date?

View attachment 117547

Thank you very much!

="60 DTE: " & TEXT($I$4-60,"DD/MM/YYYY")

 

[jdpro]

Nice! Thank you HighAndWilder!