Forum Discussion

charitos89's avatar
charitos89
Copper Contributor
Nov 19, 2021

Alternative for SEQUENCE function on EXCEL 2019

Hello.   I am using the Excel 2019 and i want to create a sequence of dates number that depends on a selected month of a year from a data validation list (screenshot). I can do that on Excel 365 (w...
office 365
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Nov 19, 2021

charitos89 

Try this:

=TRANSPOSE(ROW(INDIRECT("1:"&DAY(EOMONTH(C2,0)))))

 

  • Harisshaiq's avatar
    Harisshaiq
    Copper Contributor
    Sep 07, 2022

    I have tried but it only return only 1Detlef_Lewin 

  • charitos89's avatar
    charitos89
    Copper Contributor
    Nov 19, 2021
    It returns only the "1" number.
    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Nov 19, 2021

      charitos89 

      Unfortunately I cannot test because I use Office 365 and the formula spills. However if you want to use in inside another formula it should work as expected.
      If you just want to create a sequence of numbers in a row try this:

      In C5:
=DAY(EOMONTH(C2,0))

In D5 and copy to the right:
=IF(COLUMNS($D5:D5)>$C$5,"",COLUMNS($D5:D5))

Resources