range of dates in a single cell

[Jerry 4762]

Hi all

Im using Excel 2010.

I have a range of dates that i want to display in a single cell as text.

Eg.

Column A
1/1/15
2/1/15
3/1/15
4/1/15
.
.
.
31/1/15

What i want is to display in , say, cell B2, just the dates seperated by commas. Eg - Cell B2 should display - 1,2,3,4,5,all the way till the last date in my range.

Also, can it be done without using macros?(preferrably without macros)

Regards

Jerry

 

[jumbledore]

enter the formula DAY(A1:A10) as an array formula (ctrl-shift-enter) Then select cell B2 press F2 and then F9. You can then copy the dates from the formula bar.