Forum Discussion
How to repeat date (dd/mm/yyyy) for x amount of rows, then the following day for the next x rows...
HansVogelaar You will see I highlighted the August 20th dates, because that's the first time the formula appears in the sheet (the previous dates were added manually because they didn't match the 75 rows, they are all less than that so doing it manually for the first couple of days was easier). August 20th dates were obtained using the formula, but there are only 25 of them, then the remaining ones until the end of the sheet all respect the 75 employees rule. Hope that makes sense
The formula that I posted assumed that the first formula would be in row 3. It works differently if the first formula is lower down.
The original formula had MOD(ROW(K3,210)=2 because you want to go to the next date in row 2, 212, 422, 632 etc.
Now, you want to go to the next date on row 127, 202, 277, 349 etc. Those row numbers leave 52 when divided by 75: 127 = 75+52, 202 = 2*75+52, etc. So the formula in D128 should be
=WORKDAY.INTL(D127,IF(MOD(ROW(D128),75)=52,1,0),16)