I am looking for the formula to locate next Sunday's date. I am using
this formula now ...
... 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.
Thanks for your help.
The First Sunday of the Month (of the date in A1) is given by the formula:
'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?
Show today if today is Sunday, else show NEXT Sunday:
First Sunday of the month of the date in A1 formula remains the same.
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
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
Shikata ga nai...
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.