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