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.

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"DeanLinCPR" wrote in message
...
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.

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

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"DeanLinCPR" wrote in message
...
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