How to create ten cells each of a date range's days?

[Mr. Snrub]

I can type "01/01/2023" for example and then click on the lower-right corner of the cell and drag down so that the next cell is 01/02/2023 and the one after that is 01/03/2023. Is there an easy way to create ten cells of 01/01/2023, then ten cells of 01/02/2023, then ten cells of 01/03/2023, and so on? As it is now I have to individually type the new date, then Ctrl-D down nine cells, then manually type in the new 01/02/2023 date, then Ctrl-D fill down another nine cells, then manually type in the new 01/03/2023 date, and so on. Is there an easier way to do this?

 

[awoohaw]

try this:

WorkBook1.xlsx
	A	B
1	02/01/2023
2	02/01/2023
3	02/01/2023
4	02/01/2023
5	02/01/2023
6	02/01/2023
7	02/01/2023
8	02/01/2023
9	02/01/2023
10	02/01/2023
11	02/02/2023
12	02/02/2023
13	02/02/2023
Sheet1

Cell Formulas
Range	Formula
A1:A13	A1	=DATE(2023,2,1+INT((ROW(A1)-1)/10))

You need to input the year and month and the start day. And adjust the Row(A1) calculation as necessary. Drag down as far as you want.

 

[Peter_SSs]

Here is a way with just a single formula in the top cell. My example has 10 dates each repeated 3 times.

23 02 12.xlsm
	A
1	1/01/2023
2	1/01/2023
3	1/01/2023
4	2/01/2023
5	2/01/2023
6	2/01/2023
7	3/01/2023
8	3/01/2023
9	3/01/2023
10	4/01/2023
11	4/01/2023
12	4/01/2023
13	5/01/2023
14	5/01/2023
15	5/01/2023
16	6/01/2023
17	6/01/2023
18	6/01/2023
19	7/01/2023
20	7/01/2023
21	7/01/2023
22	8/01/2023
23	8/01/2023
24	8/01/2023
25	9/01/2023
26	9/01/2023
27	9/01/2023
28	10/01/2023
29	10/01/2023
30	10/01/2023
31
dates

Cell Formulas
Range	Formula
A1:A30	A1	=LET(NumDates,10,Repeats,3,INT(SEQUENCE(NumDates*Repeats,,DATE(2023,1,1),1/Repeats)))
Dynamic array formulas.