text and date concatenation

V

vrzimmerm

I'm using the following formula to concatenate some text and a date
into a single cell
=Concatenate("End Date for the period is; ", Data!W2) where cell W2
on the data sheet is the date I want to use. Unfortunately the
result is always "End Date for the Period is: 39327". I can't seem
to make it display in the x/x/2007 date format. What am I doing
wrong?

Thanks.
 
A

Alan

Try
="End Date for the period is; "&TEXT(Data!W2,"dd mmm yy")
You dont really need the CONCATENATE function, just use the '&' to join the
parts, obviously change the "dd mm yy" to suit the format you want.
If you want the day as well, use "dddd dd mmm yy"
Regards,
Alan.
 
Top