I'm tring to create a list that self populates.

I'm using the CONCATENATE formula, but when I use a cell with a date it brings back the number as opposed to the actual date shown.

Is there a way that it can be done so that a date is shown or is this impossible?

I don't really want to use VBA because the workbook is already full of them.

Any help will be much apprieciated.

Thanks