View original (French)

Alternative SEQUENCE formula

Solved
vcloclo1 -  

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

    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.