Help on how to generate all dates in ""s

[tisahardknocklife]

Hey all,


Perhaps I'm being a bit lazy...

But is there any way to use Excel (or something else) to generate all dates in quotes, separated by commas?


Like this:


"01/01", "01/02", "01/03", "01/04"..........all the way to "12/31"?

[6StringJazzer]

If you do this, they will be strings, not dates, and so what you can do with them is very limited. I assume you must know this, because your request was so specific.

What year? You don't show the year, but leap year will make a difference.

Put this formula in A1 to A365 for dates in 2018:

Please Login or Register  to view this content.

[protonLeah]

separated by commas?...
Does that mean all in one cell

[tisahardknocklife]

@ 6string That's right I mean in strings, which is what you gave, thanks.

I don't want any specific year, but if it gets output with a specific year, I can just find and replace the year with a blank, so that's not a problem.

This gets me closer...but protonLeah is right, I need them separated by commas....which may mean all in one cell.

[FDibbins]

Just note that doing it this way, you no longer have dates, you have text. Dates are numbers, and if you intend trying to find a date in that text string, you will need to convert 1 or the other data set - you will not be able to make s straight check

[tisahardknocklife]

My mistake with the terminology, I'm trying to use the text for a non-excel application.


Perhaps a macro can create the comma separated list of text in a cell....?

[rorya]

Copy this into the formula bar:

=TEXT(DATE(2018,1,row(1:360)),"MM/DD")

but don't press enter. Instead select everything after the = sign, then press f9. Now copy the resulting values (excluding the ={ at the start and the final } at the end) and paste it into a cell. Then just use Find/Replace to replace the semicolons with commas.