SOLVED

Please : I want to repeat each date 16 times in a row of a year

Occasional Visitor
Any solution to repeat each date 16 times in a row of a year
1 Reply
best response confirmed by PK-Prasanth (Occasional Visitor)
Solution
Assuming we're starting in row 1:
=DATE(2021,1,1)+INT((ROW()-1)/16)