text and date concatenation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vrzimmerm@hotmail.com - 21 Sep 2007 13:21 GMT

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.

Reply to this Message

Alan - 21 Sep 2007 13:43 GMT

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.

> I'm using the following formula to concatenate some text and a date
> into a single cell
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

Rate this thread: