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

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.

If you really mean next Sunday, i.e. the Sunday next after today,
then your formula points the way:

=TODAY() + 8-WEEKDAY( TODAY() )

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...