Google Sheets – How to Add Every Sunday in Sequential Order

formulasgoogle sheetsgoogle-sheets-arrayformulagoogle-sheets-dates

So I tried using the simple formula:

=date(2019,3,10) 
=date(2019,3,10)+7
=date(2019,3,10)+14
=date(2019,3,10)+21

... etc.

But when I highlight the first top 3-4 cells to drag down and formulate the pattern it doesn't work in this case. My goal is for my sheet to auto-populate all Sunday's date in the year, even continuing to the next couple years in the future.

Any recommendations?

Best Answer

  • instead of =DATE(2019,3,10)+7 use this formula and drag it down

    =DATE(2019,3,10)+ROW(A1)*7

    0