How to add every Sunday in sequential order with 3 blank cells under each date?
March 22 Blank cell Blank cell Blank cell March 29 etc etc
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
A1 : =ArrayFormula(if( mod(ROW(A1:A100),4)=1, text((round(ROW(A1:A100)/4)*7)+43730,"dddd dd mmm yy") ,) )
A1is the first sunday,
A5is the second with this formula
A9is the third :
A5:A12. You’ll see a small blue box in the lower right corner.