Recurring Day

[DeanLinCPR]

I need to create a spreadsheet that will autofill every Sunday in perpetuity.
I have tried a formula I found this formula that I tried to modify but
couldn't figure it out. This one returns every 3rd Sunday:
=DATE(YEAR(A2),MONTH(A2)+1,22)-WEEKDAY(DATE(YEAR(A2),MONTH(A2)+1,7)) Where
A2 = a given Sunday ie 10-18-9

I am not sure how it comes up with the fact that it is the 3rd Sunday but
that is what it does.

 

[Niek Otten]

Just keep adding 7 to the date and you'll get all the Saturdays to come

 

[DeanLinCPR]

Thanks!! Sometimes I amaze myself at how well I overlook the obvious