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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel with Concatenate does not format date correctly 1
Trying to get appropriate month in string of dates 3
Concatenate multiple lines 2
Looking for a Date forming function 3
Formula to fill cells based on Date of Arrival and Date of Departure 1
Using Multiple Date Ranges to pull in Data 0
date format not change in custom 2
Conditional Formatting Formula Help 3

Back
Top