Format a date in a text string

[njones3]

Hi,

I think this is probably a simple fix but for the life of me I can not work out to get it displaying properly. I have the below formula:

="as at "&TODAY() and it is returning "as at 43916"

I would like it to return the date in date format not as a number.

Thanks in advance for any help.

 

[footoo]

="as at " & Text(Today(), "d/m/yy")

Alternatively, format the cell : "as at "d/m/yy
and then the formula would be : =Today()

 

[njones3]

Thanks footoo, that has done it. Much appreciated.