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.