text and date concatenation

  • Thread starter Thread starter vrzimmerm
  • Start date Start date
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.
 
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.
 
Back
Top