Tag Info

New answers tagged


Assuming the first row is used for column headers, you can enter =arrayformula(date(2015,11,8) + floor((row(A2:A)-2)/10)) into cell A2, and get the list of dates with each repeated 10 times. This list will fill the entire first column; if more rows are added later, they will be automatically filled as well. A formula can't add new rows to a spreadsheet ...

Top 50 recent answers are included