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