Create sequential dates with each date repeated multiple times

Question

For every day of the year, I need the day repeated in 10 rows. How can I accomplish this efficiently?

e.g.
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/01/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
01/02/2019
... (all other dates)
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019
12/31/2019

Blindspots · Accepted Answer · 2024-04-05 15:18:27Z

Formula

First as a single line, then broken out into multiple lines. Use whichever you prefer as both are valid and differences are cosmetic.

=TOCOL(BYROW(SEQUENCE(EOMONTH(DATE(2019, 1, 1), 11)-DATE(2019, 1, 1)+1, 1, DATE(2019, 1, 1)), LAMBDA(d, ARRAYFORMULA(IFERROR(SEQUENCE(1, 10)/0, d)))))

=TOCOL(
   BYROW(
     SEQUENCE(EOMONTH(DATE(2019,1,1), 11)-DATE(2019,1,1)+1, 1, DATE(2019,1,1)),
     LAMBDA(d, 
       ARRAYFORMULA(
         IFERROR(
           SEQUENCE(1, 10)/0, d)))))

Using LET

Same formula as above but allows easier modification if the formula will be reused. Only the year, yr, and number of repeats per date, rpt, need to be edited.

=LET(yr,2019, rpt,10, dat,DATE(yr, 1, 1), daze,EOMONTH(dat, 11)-dat+1, TOCOL(BYROW(SEQUENCE(daze, 1, dat), LAMBDA(d, ARRAYFORMULA(IFERROR(SEQUENCE(1, rpt)/0, d))))))

=LET(
   yr,2019, rpt,10,
   dat,DATE(yr,1,1), 
   daze,EOMONTH(dat, 11)-dat+1,
   TOCOL(
     BYROW(
       SEQUENCE(daze, 1, dat),
       LAMBDA(d, 
         ARRAYFORMULA(
           IFERROR(
             SEQUENCE(1, rpt)/0, d))))))

Explanation

A sequence of numbers is created equivalent to every date in the year 2019:
- 365 numbers starting from 43,466 and incrementing by 1:
- Note: 43,466 = DATE(2019, 01, 01) = DATEVALUE(" 1/1/2019 ")
- EOMONTH is used to determine the last day of the month that's 11 months from 1/1/2019: 12/31/2019.
- 1 is added to the difference between the two dates to return 365 days.
BYROW passes that 365-date number sequence row-by-row into a LAMDA function that stores the current number in d.
The LAMBDA's formula creates an array of 10 instances of d by creating a sequence of 10 DIV/0 errors and IFERROR replaces each with d
TOROW takes the result of the BYROW function, an 365x10 (row x column) array and converts it to a single column, where the date changes every ten rows.

Variation w/ MAKEARRAY

=LET(yr,2019, rpt,3,
  dat,DATE(yr,1,1), 
  daze,EOMONTH(dat, 11)-dat+1,
  seq,SEQUENCE(daze, 1, dat), 
    TOCOL(
      MAKEARRAY(daze, rpt,
        LAMBDA(r,c, INDEX(seq, r)))))

user0 · Accepted Answer · 2019-01-11 04:10:22Z

=ARRAYFORMULA(TO_DATE(TRANSPOSE(SPLIT(REPT(DATE(2019,1,1)&"|",10)&REPT(DATE(2019,1,1)+1&"|",10)&
 REPT(DATE(2019,1,1)+2&"|",10)&REPT(DATE(2019,1,1)+3&"|",10)&REPT(DATE(2019,1,1)+4&"|",10)&
 REPT(DATE(2019,1,1)+5&"|",10)&REPT(DATE(2019,1,1)+6&"|",10)&REPT(DATE(2019,1,1)+7&"|",10)&
 REPT(DATE(2019,1,1)+8&"|",10)&REPT(DATE(2019,1,1)+9&"|",10)&REPT(DATE(2019,1,1)+10&"|",10)&
 REPT(DATE(2019,1,1)+11&"|",10)&REPT(DATE(2019,1,1)+12&"|",10)&REPT(DATE(2019,1,1)+13&"|",10)&
 REPT(DATE(2019,1,1)+14&"|",10)&REPT(DATE(2019,1,1)+15&"|",10)&REPT(DATE(2019,1,1)+16&"|",10)&
 REPT(DATE(2019,1,1)+17&"|",10)&REPT(DATE(2019,1,1)+18&"|",10)&REPT(DATE(2019,1,1)+19&"|",10)&
 REPT(DATE(2019,1,1)+20&"|",10)&REPT(DATE(2019,1,1)+21&"|",10)&REPT(DATE(2019,1,1)+22&"|",10)&
 REPT(DATE(2019,1,1)+23&"|",10)&REPT(DATE(2019,1,1)+24&"|",10)&REPT(DATE(2019,1,1)+25&"|",10)&
 REPT(DATE(2019,1,1)+26&"|",10)&REPT(DATE(2019,1,1)+27&"|",10)&REPT(DATE(2019,1,1)+28&"|",10)&
 REPT(DATE(2019,1,1)+29&"|",10)&REPT(DATE(2019,1,1)+30&"|",10)&REPT(DATE(2019,1,1)+31&"|",10)&
 REPT(DATE(2019,1,1)+32&"|",10)&REPT(DATE(2019,1,1)+33&"|",10)&REPT(DATE(2019,1,1)+34&"|",10)&
 REPT(DATE(2019,1,1)+35&"|",10)&REPT(DATE(2019,1,1)+36&"|",10)&REPT(DATE(2019,1,1)+37&"|",10)&
 REPT(DATE(2019,1,1)+38&"|",10)&REPT(DATE(2019,1,1)+39&"|",10)&REPT(DATE(2019,1,1)+40&"|",10)&
 REPT(DATE(2019,1,1)+41&"|",10)&REPT(DATE(2019,1,1)+42&"|",10)&REPT(DATE(2019,1,1)+43&"|",10)&
 REPT(DATE(2019,1,1)+44&"|",10)&REPT(DATE(2019,1,1)+45&"|",10)&REPT(DATE(2019,1,1)+46&"|",10)&
 REPT(DATE(2019,1,1)+47&"|",10)&REPT(DATE(2019,1,1)+48&"|",10)&REPT(DATE(2019,1,1)+49&"|",10)&
 REPT(DATE(2019,1,1)+50&"|",10)&REPT(DATE(2019,1,1)+51&"|",10)&REPT(DATE(2019,1,1)+52&"|",10)&
 REPT(DATE(2019,1,1)+53&"|",10)&REPT(DATE(2019,1,1)+54&"|",10)&REPT(DATE(2019,1,1)+55&"|",10)&
 REPT(DATE(2019,1,1)+56&"|",10)&REPT(DATE(2019,1,1)+57&"|",10)&REPT(DATE(2019,1,1)+58&"|",10)&
 REPT(DATE(2019,1,1)+59&"|",10)&REPT(DATE(2019,1,1)+60&"|",10)&REPT(DATE(2019,1,1)+61&"|",10)&
 REPT(DATE(2019,1,1)+62&"|",10)&REPT(DATE(2019,1,1)+63&"|",10)&REPT(DATE(2019,1,1)+64&"|",10)&
 REPT(DATE(2019,1,1)+65&"|",10)&REPT(DATE(2019,1,1)+66&"|",10)&REPT(DATE(2019,1,1)+67&"|",10)&
 REPT(DATE(2019,1,1)+68&"|",10)&REPT(DATE(2019,1,1)+69&"|",10)&REPT(DATE(2019,1,1)+70&"|",10)&
 REPT(DATE(2019,1,1)+71&"|",10)&REPT(DATE(2019,1,1)+72&"|",10)&REPT(DATE(2019,1,1)+73&"|",10)&
 REPT(DATE(2019,1,1)+74&"|",10)&REPT(DATE(2019,1,1)+75&"|",10)&REPT(DATE(2019,1,1)+76&"|",10)&
 REPT(DATE(2019,1,1)+77&"|",10)&REPT(DATE(2019,1,1)+78&"|",10)&REPT(DATE(2019,1,1)+79&"|",10)&
 REPT(DATE(2019,1,1)+80&"|",10)&REPT(DATE(2019,1,1)+81&"|",10)&REPT(DATE(2019,1,1)+82&"|",10)&
 REPT(DATE(2019,1,1)+83&"|",10)&REPT(DATE(2019,1,1)+84&"|",10)&REPT(DATE(2019,1,1)+85&"|",10)&
 REPT(DATE(2019,1,1)+86&"|",10)&REPT(DATE(2019,1,1)+87&"|",10)&REPT(DATE(2019,1,1)+88&"|",10)&
 REPT(DATE(2019,1,1)+89&"|",10)&REPT(DATE(2019,1,1)+90&"|",10)&REPT(DATE(2019,1,1)+91&"|",10)&
 REPT(DATE(2019,1,1)+92&"|",10)&REPT(DATE(2019,1,1)+93&"|",10)&REPT(DATE(2019,1,1)+94&"|",10)&
 REPT(DATE(2019,1,1)+95&"|",10)&REPT(DATE(2019,1,1)+96&"|",10)&REPT(DATE(2019,1,1)+97&"|",10)&
 REPT(DATE(2019,1,1)+98&"|",10)&REPT(DATE(2019,1,1)+99&"|",10)&REPT(DATE(2019,1,1)+100&"|",10)&
 REPT(DATE(2019,1,1)+101&"|",10)&REPT(DATE(2019,1,1)+102&"|",10)&REPT(DATE(2019,1,1)+103&"|",10)&
 REPT(DATE(2019,1,1)+104&"|",10)&REPT(DATE(2019,1,1)+105&"|",10)&REPT(DATE(2019,1,1)+106&"|",10)&
 REPT(DATE(2019,1,1)+107&"|",10)&REPT(DATE(2019,1,1)+108&"|",10)&REPT(DATE(2019,1,1)+109&"|",10)&
 REPT(DATE(2019,1,1)+110&"|",10)&REPT(DATE(2019,1,1)+111&"|",10)&REPT(DATE(2019,1,1)+112&"|",10)&
 REPT(DATE(2019,1,1)+113&"|",10)&REPT(DATE(2019,1,1)+114&"|",10)&REPT(DATE(2019,1,1)+115&"|",10)&
 REPT(DATE(2019,1,1)+116&"|",10)&REPT(DATE(2019,1,1)+117&"|",10)&REPT(DATE(2019,1,1)+118&"|",10)&
 REPT(DATE(2019,1,1)+119&"|",10)&REPT(DATE(2019,1,1)+120&"|",10)&REPT(DATE(2019,1,1)+121&"|",10)&
 REPT(DATE(2019,1,1)+122&"|",10)&REPT(DATE(2019,1,1)+123&"|",10)&REPT(DATE(2019,1,1)+124&"|",10)&
 REPT(DATE(2019,1,1)+125&"|",10)&REPT(DATE(2019,1,1)+126&"|",10)&REPT(DATE(2019,1,1)+127&"|",10)&
 REPT(DATE(2019,1,1)+128&"|",10)&REPT(DATE(2019,1,1)+129&"|",10)&REPT(DATE(2019,1,1)+130&"|",10)&
 REPT(DATE(2019,1,1)+131&"|",10)&REPT(DATE(2019,1,1)+132&"|",10)&REPT(DATE(2019,1,1)+133&"|",10)&
 REPT(DATE(2019,1,1)+134&"|",10)&REPT(DATE(2019,1,1)+135&"|",10)&REPT(DATE(2019,1,1)+136&"|",10)&
 REPT(DATE(2019,1,1)+137&"|",10)&REPT(DATE(2019,1,1)+138&"|",10)&REPT(DATE(2019,1,1)+139&"|",10)&
 REPT(DATE(2019,1,1)+140&"|",10)&REPT(DATE(2019,1,1)+141&"|",10)&REPT(DATE(2019,1,1)+142&"|",10)&
 REPT(DATE(2019,1,1)+143&"|",10)&REPT(DATE(2019,1,1)+144&"|",10)&REPT(DATE(2019,1,1)+145&"|",10)&
 REPT(DATE(2019,1,1)+146&"|",10)&REPT(DATE(2019,1,1)+147&"|",10)&REPT(DATE(2019,1,1)+148&"|",10)&
 REPT(DATE(2019,1,1)+149&"|",10)&REPT(DATE(2019,1,1)+150&"|",10)&REPT(DATE(2019,1,1)+151&"|",10)&
 REPT(DATE(2019,1,1)+152&"|",10)&REPT(DATE(2019,1,1)+153&"|",10)&REPT(DATE(2019,1,1)+154&"|",10)&
 REPT(DATE(2019,1,1)+155&"|",10)&REPT(DATE(2019,1,1)+156&"|",10)&REPT(DATE(2019,1,1)+157&"|",10)&
 REPT(DATE(2019,1,1)+158&"|",10)&REPT(DATE(2019,1,1)+159&"|",10)&REPT(DATE(2019,1,1)+160&"|",10)&
 REPT(DATE(2019,1,1)+161&"|",10)&REPT(DATE(2019,1,1)+162&"|",10)&REPT(DATE(2019,1,1)+163&"|",10)&
 REPT(DATE(2019,1,1)+164&"|",10)&REPT(DATE(2019,1,1)+165&"|",10)&REPT(DATE(2019,1,1)+166&"|",10)&
 REPT(DATE(2019,1,1)+167&"|",10)&REPT(DATE(2019,1,1)+168&"|",10)&REPT(DATE(2019,1,1)+169&"|",10)&
 REPT(DATE(2019,1,1)+170&"|",10)&REPT(DATE(2019,1,1)+171&"|",10)&REPT(DATE(2019,1,1)+172&"|",10)&
 REPT(DATE(2019,1,1)+173&"|",10)&REPT(DATE(2019,1,1)+174&"|",10)&REPT(DATE(2019,1,1)+175&"|",10)&
 REPT(DATE(2019,1,1)+176&"|",10)&REPT(DATE(2019,1,1)+177&"|",10)&REPT(DATE(2019,1,1)+178&"|",10)&
 REPT(DATE(2019,1,1)+179&"|",10)&REPT(DATE(2019,1,1)+180&"|",10)&REPT(DATE(2019,1,1)+181&"|",10)&
 REPT(DATE(2019,1,1)+182&"|",10)&REPT(DATE(2019,1,1)+183&"|",10)&REPT(DATE(2019,1,1)+184&"|",10)&
 REPT(DATE(2019,1,1)+185&"|",10)&REPT(DATE(2019,1,1)+186&"|",10)&REPT(DATE(2019,1,1)+187&"|",10)&
 REPT(DATE(2019,1,1)+188&"|",10)&REPT(DATE(2019,1,1)+189&"|",10)&REPT(DATE(2019,1,1)+190&"|",10)&
 REPT(DATE(2019,1,1)+191&"|",10)&REPT(DATE(2019,1,1)+192&"|",10)&REPT(DATE(2019,1,1)+193&"|",10)&
 REPT(DATE(2019,1,1)+194&"|",10)&REPT(DATE(2019,1,1)+195&"|",10)&REPT(DATE(2019,1,1)+196&"|",10)&
 REPT(DATE(2019,1,1)+197&"|",10)&REPT(DATE(2019,1,1)+198&"|",10)&REPT(DATE(2019,1,1)+199&"|",10)&
 REPT(DATE(2019,1,1)+200&"|",10)&REPT(DATE(2019,1,1)+201&"|",10)&REPT(DATE(2019,1,1)+202&"|",10)&
 REPT(DATE(2019,1,1)+203&"|",10)&REPT(DATE(2019,1,1)+204&"|",10)&REPT(DATE(2019,1,1)+205&"|",10)&
 REPT(DATE(2019,1,1)+206&"|",10)&REPT(DATE(2019,1,1)+207&"|",10)&REPT(DATE(2019,1,1)+208&"|",10)&
 REPT(DATE(2019,1,1)+209&"|",10)&REPT(DATE(2019,1,1)+210&"|",10)&REPT(DATE(2019,1,1)+211&"|",10)&
 REPT(DATE(2019,1,1)+212&"|",10)&REPT(DATE(2019,1,1)+213&"|",10)&REPT(DATE(2019,1,1)+214&"|",10)&
 REPT(DATE(2019,1,1)+215&"|",10)&REPT(DATE(2019,1,1)+216&"|",10)&REPT(DATE(2019,1,1)+217&"|",10)&
 REPT(DATE(2019,1,1)+218&"|",10)&REPT(DATE(2019,1,1)+219&"|",10)&REPT(DATE(2019,1,1)+220&"|",10)&
 REPT(DATE(2019,1,1)+221&"|",10)&REPT(DATE(2019,1,1)+222&"|",10)&REPT(DATE(2019,1,1)+223&"|",10)&
 REPT(DATE(2019,1,1)+224&"|",10)&REPT(DATE(2019,1,1)+225&"|",10)&REPT(DATE(2019,1,1)+226&"|",10)&
 REPT(DATE(2019,1,1)+227&"|",10)&REPT(DATE(2019,1,1)+228&"|",10)&REPT(DATE(2019,1,1)+229&"|",10)&
 REPT(DATE(2019,1,1)+230&"|",10)&REPT(DATE(2019,1,1)+231&"|",10)&REPT(DATE(2019,1,1)+232&"|",10)&
 REPT(DATE(2019,1,1)+233&"|",10)&REPT(DATE(2019,1,1)+234&"|",10)&REPT(DATE(2019,1,1)+235&"|",10)&
 REPT(DATE(2019,1,1)+236&"|",10)&REPT(DATE(2019,1,1)+237&"|",10)&REPT(DATE(2019,1,1)+238&"|",10)&
 REPT(DATE(2019,1,1)+239&"|",10)&REPT(DATE(2019,1,1)+240&"|",10)&REPT(DATE(2019,1,1)+241&"|",10)&
 REPT(DATE(2019,1,1)+242&"|",10)&REPT(DATE(2019,1,1)+243&"|",10)&REPT(DATE(2019,1,1)+244&"|",10)&
 REPT(DATE(2019,1,1)+245&"|",10)&REPT(DATE(2019,1,1)+246&"|",10)&REPT(DATE(2019,1,1)+247&"|",10)&
 REPT(DATE(2019,1,1)+248&"|",10)&REPT(DATE(2019,1,1)+249&"|",10)&REPT(DATE(2019,1,1)+250&"|",10)&
 REPT(DATE(2019,1,1)+251&"|",10)&REPT(DATE(2019,1,1)+252&"|",10)&REPT(DATE(2019,1,1)+253&"|",10)&
 REPT(DATE(2019,1,1)+254&"|",10)&REPT(DATE(2019,1,1)+255&"|",10)&REPT(DATE(2019,1,1)+256&"|",10)&
 REPT(DATE(2019,1,1)+257&"|",10)&REPT(DATE(2019,1,1)+258&"|",10)&REPT(DATE(2019,1,1)+259&"|",10)&
 REPT(DATE(2019,1,1)+260&"|",10)&REPT(DATE(2019,1,1)+261&"|",10)&REPT(DATE(2019,1,1)+262&"|",10)&
 REPT(DATE(2019,1,1)+263&"|",10)&REPT(DATE(2019,1,1)+264&"|",10)&REPT(DATE(2019,1,1)+265&"|",10)&
 REPT(DATE(2019,1,1)+266&"|",10)&REPT(DATE(2019,1,1)+267&"|",10)&REPT(DATE(2019,1,1)+268&"|",10)&
 REPT(DATE(2019,1,1)+269&"|",10)&REPT(DATE(2019,1,1)+270&"|",10)&REPT(DATE(2019,1,1)+271&"|",10)&
 REPT(DATE(2019,1,1)+272&"|",10)&REPT(DATE(2019,1,1)+273&"|",10)&REPT(DATE(2019,1,1)+274&"|",10)&
 REPT(DATE(2019,1,1)+275&"|",10)&REPT(DATE(2019,1,1)+276&"|",10)&REPT(DATE(2019,1,1)+277&"|",10)&
 REPT(DATE(2019,1,1)+278&"|",10)&REPT(DATE(2019,1,1)+279&"|",10)&REPT(DATE(2019,1,1)+280&"|",10)&
 REPT(DATE(2019,1,1)+281&"|",10)&REPT(DATE(2019,1,1)+282&"|",10)&REPT(DATE(2019,1,1)+283&"|",10)&
 REPT(DATE(2019,1,1)+284&"|",10)&REPT(DATE(2019,1,1)+285&"|",10)&REPT(DATE(2019,1,1)+286&"|",10)&
 REPT(DATE(2019,1,1)+287&"|",10)&REPT(DATE(2019,1,1)+288&"|",10)&REPT(DATE(2019,1,1)+289&"|",10)&
 REPT(DATE(2019,1,1)+290&"|",10)&REPT(DATE(2019,1,1)+291&"|",10)&REPT(DATE(2019,1,1)+292&"|",10)&
 REPT(DATE(2019,1,1)+293&"|",10)&REPT(DATE(2019,1,1)+294&"|",10)&REPT(DATE(2019,1,1)+295&"|",10)&
 REPT(DATE(2019,1,1)+296&"|",10)&REPT(DATE(2019,1,1)+297&"|",10)&REPT(DATE(2019,1,1)+298&"|",10)&
 REPT(DATE(2019,1,1)+299&"|",10)&REPT(DATE(2019,1,1)+300&"|",10)&REPT(DATE(2019,1,1)+301&"|",10)&
 REPT(DATE(2019,1,1)+302&"|",10)&REPT(DATE(2019,1,1)+303&"|",10)&REPT(DATE(2019,1,1)+304&"|",10)&
 REPT(DATE(2019,1,1)+305&"|",10)&REPT(DATE(2019,1,1)+306&"|",10)&REPT(DATE(2019,1,1)+307&"|",10)&
 REPT(DATE(2019,1,1)+308&"|",10)&REPT(DATE(2019,1,1)+309&"|",10)&REPT(DATE(2019,1,1)+310&"|",10)&
 REPT(DATE(2019,1,1)+311&"|",10)&REPT(DATE(2019,1,1)+312&"|",10)&REPT(DATE(2019,1,1)+313&"|",10)&
 REPT(DATE(2019,1,1)+314&"|",10)&REPT(DATE(2019,1,1)+315&"|",10)&REPT(DATE(2019,1,1)+316&"|",10)&
 REPT(DATE(2019,1,1)+317&"|",10)&REPT(DATE(2019,1,1)+318&"|",10)&REPT(DATE(2019,1,1)+319&"|",10)&
 REPT(DATE(2019,1,1)+320&"|",10)&REPT(DATE(2019,1,1)+321&"|",10)&REPT(DATE(2019,1,1)+322&"|",10)&
 REPT(DATE(2019,1,1)+323&"|",10)&REPT(DATE(2019,1,1)+324&"|",10)&REPT(DATE(2019,1,1)+325&"|",10)&
 REPT(DATE(2019,1,1)+326&"|",10)&REPT(DATE(2019,1,1)+327&"|",10)&REPT(DATE(2019,1,1)+328&"|",10)&
 REPT(DATE(2019,1,1)+329&"|",10)&REPT(DATE(2019,1,1)+330&"|",10)&REPT(DATE(2019,1,1)+331&"|",10)&
 REPT(DATE(2019,1,1)+332&"|",10)&REPT(DATE(2019,1,1)+333&"|",10)&REPT(DATE(2019,1,1)+334&"|",10)&
 REPT(DATE(2019,1,1)+335&"|",10)&REPT(DATE(2019,1,1)+336&"|",10)&REPT(DATE(2019,1,1)+337&"|",10)&
 REPT(DATE(2019,1,1)+338&"|",10)&REPT(DATE(2019,1,1)+339&"|",10)&REPT(DATE(2019,1,1)+340&"|",10)&
 REPT(DATE(2019,1,1)+341&"|",10)&REPT(DATE(2019,1,1)+342&"|",10)&REPT(DATE(2019,1,1)+343&"|",10)&
 REPT(DATE(2019,1,1)+344&"|",10)&REPT(DATE(2019,1,1)+345&"|",10)&REPT(DATE(2019,1,1)+346&"|",10)&
 REPT(DATE(2019,1,1)+347&"|",10)&REPT(DATE(2019,1,1)+348&"|",10)&REPT(DATE(2019,1,1)+349&"|",10)&
 REPT(DATE(2019,1,1)+350&"|",10)&REPT(DATE(2019,1,1)+351&"|",10)&REPT(DATE(2019,1,1)+352&"|",10)&
 REPT(DATE(2019,1,1)+353&"|",10)&REPT(DATE(2019,1,1)+354&"|",10)&REPT(DATE(2019,1,1)+355&"|",10)&
 REPT(DATE(2019,1,1)+356&"|",10)&REPT(DATE(2019,1,1)+357&"|",10)&REPT(DATE(2019,1,1)+358&"|",10)&
 REPT(DATE(2019,1,1)+359&"|",10)&REPT(DATE(2019,1,1)+360&"|",10)&REPT(DATE(2019,1,1)+361&"|",10)&
 REPT(DATE(2019,1,1)+362&"|",10)&REPT(DATE(2019,1,1)+363&"|",10)&REPT(DATE(2019,1,1)+364&"|",10)
 ,"|",1))))

Stack Exchange Network

Create sequential dates with each date repeated multiple times

2 Answers 2

Formula

Using LET

Explanation

Variation w/ MAKEARRAY

Your Answer

Not the answer you're looking for? Browse other questions tagged
google-sheets
formulas
google-sheets-arrayformula
or ask your own question.

Hot Network Questions

Create sequential dates with each date repeated multiple times

2 Answers 2

Formula

Using LET

Explanation

Variation w/ MAKEARRAY

Your Answer

Sign up or log in

Post as a guest

Not the answer you're looking for? Browse other questions tagged google-sheetsformulasgoogle-sheets-arrayformula or ask your own question.

Related

Hot Network Questions

Not the answer you're looking for? Browse other questions tagged
google-sheets
formulas
google-sheets-arrayformula
or ask your own question.