Concatening a text and a date

[c991257]

Hi

I'm having trouble concatenating a text string with a date:

I cell a1 I have the date 03-may-06

In a different cell I have the function:
=CONCATENATE(" This date: ",a1)

which returns:

This date: 38840.

I can't seem to find a function that converts the serial back to th
date format that I entered.

I could use =CONCATENATE("This date: "
DATE(YEAR(A1),MONTH(A1),DAY(A1)))

But that gives me
This date: 03/05/2006

Anyone?

/Mølle

 

[Bearacade]

=CONCATENATE(" This date: ",TEXT(A1,"dd-mmm-yy")

 

[Alan]

Try with the date in A1,
="This Date: "&TEXT(A1,"dd-mmm-yy")
Regards,
Alan.

 

[c991257]

Thanks

/Mølle