Problem getting date-value to combined text-cell

Hi,

First time posting here, lets see if anyone can help me I tried to add the excel but can't attach it for some reason?

As you can see in the picture, the idea is that A2 should contain an order date, B2 tells whether it is an order, if it is an order then it should result in the order date together with text appearing in C2.

But the problem is that I get the date value while the idea is that the text in C2 should be kind to copy into another program to easily inform which date the order is placed.

In the real example, it is important that the date field is just a date, so it is not an option to make it a text field.

In the real example, there is even more text to enter, not just the date. But for the sake of simplicity, I stripped down the excel to the exact problem.

In short: I want to combine a text with date in a cell while retaining the date format; YYYY-MM-DD.

The formula used today is:
=
IF(
B3 = "Order";
"Order Date:"&(A3);
"No order"
)

orderdate.JPG

Thanks for the help

Thanks for the response. Though this will give me another problems as I need A3 to be a DATE cell for PIVOT and other stuff.

EDIT: Oh, you ment change it in the "Response"-cell. I will try that.

It worked :D That was way to easy, thanks for the help!