Hi guys,

I'm trying to put together dates into one cell and when I do it gives the actual value (ie. 01/01/00 = 36526). So I have A1 = 01/01/00 and B1 = 06/01/00. I'm trying to put it together in cell C1 with this formula:

=A1&","&" "&B1 result = 36526, 36678

what I need is to make it a date format resulting in = 01/01/00, 06/01/00. I tried ofcourse to format it w/ date, also tried to put custom (mm/dd/yyyy). The data can go up to 20 or even more dates.

I appreciate any help, thanks