New answers tagged

0

Delete range A2:A and paste this into A2 cell and for next month just type August in A1 cell: =ARRAYFORMULA(TEXT({ROW(INDIRECT("A"& DATEVALUE(DATE(2019, MONTH(A1&1), 1))&":"& DATEVALUE(DATE(2019, MONTH(A1&1), 7)))); "Week 1"; ROW(INDIRECT("A"& DATEVALUE(DATE(2019, MONTH(A1&1), 8))&":"& DATEVALUE(DATE(2019, MONTH(A1&...


Top 50 recent answers are included