# Excel - Find next Sunday

Asked By Keyrookie on 21-Jun-12 05:15 PM
```Greetings all,

I am looking for the formula to locate next Sunday's date.  I am 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 am wanting to simplify the process and not have multiple fomulas.

K

--
Keyrookie```

Ron Rosenfeld replied to Keyrookie on 21-Jun-12 11:11 PM
```The First Sunday of the Month (of the date in A1) is given by the formula:

=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1))```
Keyrookie replied to Ron Rosenfeld on 22-Jun-12 07:21 AM
```'Ron Rosenfeld[_2_ Wrote:

Thank you, Ron.  This formula works great!

However, after testing this for my use I realized I need to show the
current Sunday before I show the next Sunday.  In other words, if today
is Sunday, I need to show the current date.  Then on Monday I need to
show the next Sunday's date.

Is that possible?

--
Keyrookie```
James Ravenswood replied to Keyrookie on 22-Jun-12 10:49 AM
```Something like:

=IF(WEEKDAY(TODAY())=1,TODAY(),TODAY()+8-WEEKDAY(TODAY()))```
Ron Rosenfeld replied to Keyrookie on 22-Jun-12 06:53 PM
```Minor change:

Show today if today is Sunday, else show NEXT Sunday:

=A1+7-WEEKDAY(A1-1)

First Sunday of the month of the date in A1 formula remains the same.

=A1-DAY(A1)+8-WEEKDAY(A1-DAY(A1))```
Keyrookie replied to James Ravenswood on 22-Jun-12 04:51 PM
```James Ravenswood;1603037 Wrote:

Thanks James. but I could not get it to work.  I tried putting A1 in the
() behind the TODAY's in the formula and I got an error message.  Am I
missing something?

--
Keyrookie```
Stan Brown replied to Keyrookie on 23-Jun-12 09:52 AM
```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
`My equation does not depend on A1.  It calculates the date of the next Sunday from today.  If today happends to be a Sunday, it gives today's date.`