Forum Discussion

Burns-Mills's avatar
Burns-Mills
Copper Contributor
Jun 26, 2023

Formula Help with Sequencing

Ello

 

I'm running a daily quiz for my work. I have a table set up in Excel withe the formula to generate the dates e.g. (=IF(WEEKDAY(A20,3)<5, A20,""). My issue is, I would like to be able have a sequence of the day numbers to track what number day the quiz is up to: See what i am refering to in the picture below. Instead of typing or autofilling. Is there a formula that i can set up or a rule that will work in conjuction with my dates 

 

Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jun 27, 2023

    Burns-Mills 

    =IF(A2<>"",MAX(B$1:B1)+1,"")

     

    Insert formula in B2 and dropdown.

    See Example file.

     

    You can use SEQUENCE function, is available in Excel for Microsoft 365 and Excel 2021 that support dynamic arrays. 

    =SEQUENCE(1,10,TODAY(),1)

    Additional for instance, to generate a sequence of workdays starting on a specific date, you can use the formula: =WORKDAY(date-1, SEQUENCE(sequence_size)).

     

Share

Resources