Add Specific Text to Formula

[webcommerce]

Hi Folks,
This is probably a simple question, but I cannot find a way to do this.

I want to get today's date combined with text as the result.

The result should be (eg): POSITION REPORT 16/04/17
where the date is TODAY().

Any ideas anyone?
Much appreciated.
Ron S

[sandy666]

try ="POSITION REPORT "&TEXT(TODAY(),"dd/mm/yyyy")

[webcommerce]

Hey Sandy, That worked just great. I had tried various versions of it already,
just assumed the dd/mm/yyyy would be done using cell format.

I learned something new today, now I can go back to sleep!!
Thank you.

[sandy666]

Glad to help
(result is text so you can't use cell format for date because date is a number that is why TEXT() function is used)
so,
00repsolv.gif

[sandy666]

If you don't know how to mark thread as SOLVED, go to your first post, look at right top corner and from Thread Tools select Solved

btw. thanks for Rep.