The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be one dimensional, or two-dimensional, determined by rows and columns arguments.
A combination of the sequence, weekday, choose and the date function can be used to generate a simple yet dynamic function