On Thu, 21 Jun 2012 21:15:34 +0000, Keyrookie wrote:


Greetings all,

I'm looking for the formula to locate next Sunday's date. I'm using
this formula now ...
=DATE(YEAR($A$1),MONTH($A$1),1+7*1)-WEEKDAY(DATE(YEAR($A$1),MONTH($A$1),8-1))
.. to locate the 1st Sunday of the month and then I have 4 cells that
will locate the following Sunday's of the month.

I'm wanting to simplify the process and not have multiple fomulas.

Thanks for your help.

K
"Next" Sunday is given by the formula: =A1+8-WEEKDAY(A1)

The First Sunday of the Month (of the date in A1) is given by the formula:

=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1))