Forum Discussion
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 ...
=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)).