Macro to have strings of dates in one cell

[tisahardknocklife]

Hey all,


I'm looking to get some sort of macro that outputs the following into a single cell

All the dates (non leap-year) from Jan 1 to Dec 31.
Year on the end does not matter.

"01/01", "01/02", "01/03", "01/04"..... "12/31"

I know its kind of a lazy thing to ask for, but all help appreciated!

[kersplash]

Haven't you asked the same question here?

https://www.excelforum.com/excel-gen...ates-in-s.html