date presentation in concatenate formula

My colleague and I wish to concatenate a set of data which includes a mixture of event names and dates. A problem occurs in that the dates are picked up as general numbers, resulting in confusing data. The example shows that a date that is entered in what I might call text format is presented as a readable date in the concatenation. This is not true of dates that are in number format. The data we are working presents the dates in number format, such as 10/08/2015. I am looking either for a way to convert this date and others like it into a text format like Aug 10 2015 or to have it present as Aug 20 2015.
concatenate and date presentation aug 10 2015.xlsx

Thank you kindly, Trevor. As my colleague and I work on the report, we encounter date cells where there is no data provided. The concatenation formula using TEXT creates a date of 00/01/1900. It would be preferred if this was not the case. If there is not date provided in the data, no date is wanted in the compilation. Any ideas for this? Thank you.

Thank you, Tony and TMS. This is not quite working out for us. I want to attach my trial, but I confess I cannot find the attach icon in this reply window. Can you help me with that and I will show you where I am stuck? Thanks.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Use this when testing a mixed format date:

Please Login or Register  to view this content.

So your concatenation test formula will look like this:

Please Login or Register  to view this content.

Thanks, all, for your suggestions. I am working with a colleague who has a more elaborate set of data tconcatenate and date presentation aug 11.1 2015.xlsx.xlshan the simple one I was using to get the basic concepts in place. I attach the data. The report is trying to capture data from various columns in order to provide an at a glance record of points of contact with the clients, in this case ABC Church. The formula has been built from columns J to V. If the formula goes much further we get an error message that there are too many arguments. The first row shows the formula and the results. The second row shows the desired results, e.g. eliminating the results of 00/01/1900 which come from blank date columns t and v. How does one check for blank cells without getting the word "false" into the concatenation? Should it be possible to include the columns up to CZ in the formula? Is there a better way to provide an at a glance rendering of columns J to CZ than concatentation? What is the best formula to use.

Sorry, Flame, I was typing when yours came in. Does your solution mesh with the updated data I sent? Thanks.

Thanks to all who contributed to this discussion. My colleague and I were able to work out our report. One consideration we dealt with was that we were using a concatenate formula. The responses received seemed to be more along the lines of a series of &'s. Thanks again.

& is shorthand for concatenate.
It serves exactly the same purpose.

=A1&B1&C1
Is the same as
=CONCATENATE(A1,B1,C1)

Thanks, Jonmo.