Find next Sunday
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
|