Refer to cell using date format with formula?

[Jyggalag]

Hi all,

I have the following formula:

It checks if the cell in C9 is blank (which it is not, the text is just hidden) and then returns the current date of today.

However, I am also referring to cell C7 in another cell, specifically like this:

My issue is, obviously, that the cell returns the value 44606 rather than the date value from cell C7.

Can I somehow bypass this problem, so cell A39 correctly returns "X Tracking Status 14/02/2022" instead?

Thank you everybody!

Kind regards,
Jyggalag

 

[arthurbr]

Try

="Tracking Status "& text($C$7,"d/mm/yyyy")

 

[Jyggalag]

Try

="Tracking Status "& text($C$7,"d/mm/yyyy")

It worked!!

Thank you so much!! I truly appreciate it You've saved me a bunch of trouble :D

My full code for anybody wondering (obviously a 99% copy of arthurbr's code):

=+ "XYZ Tracking Status" & " " & TEXT( $C$7, "d/mm/yyyy")

 

[arthurbr]

BTW the "+" sign is not needed, that's a remnant form Lotus I think