View original (French)

Alternative SEQUENCE formula

Solved
vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   -  
vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   -

Hello,

I'm using Excel 2016 and I'm looking for an alternative to the SEQUENCE formula to be compatible with this version.

Formula: =SEQUENCE(6,7,WORKDAY.INTL(DATEVALUE(Month&Year)+1,-1,"0111111"))

Thank you

2 answers

  1.
    bigoudiii Posted messages 276 Registration date   Status Member Last intervention   91
     

    Hello,

    You won't be able to have a single dynamic formula. You need to rebuild your table.

    For example, to get your first date, in C3 you put:

     =WORKDAY.INTL(DATEVALUE(month&year)+1,-1,"0111111")

    In D3 you put =C3+1 and copy it to the right.

    In C4 you put C3+7, and copy it down and to the right.

    1
  2. vcloclo1 Posted messages 493 Registration date   Status Member Last intervention   33
     

    Hello,

    Thank you, it's working great.

    @+

    0