Change date to the following Sunday

I have a series of dates and I would like to create in the next column formulas that return the following Sunday.

How can I do this?

Thanks,
Justin

If date is in A1

=A1+7-WEEKDAY(A1-1)

If A1 is a Sunday then the formula returns the same date

It's not working. The first cell I want to pull from is E4 so I replaced A1 with E4. It's giving me a "#Value!" message.

Am I doing something wrong. It seems like a pretty straight forward formula.

Thanks,
Justin

Got it! I just needed to put (E4) after the WEEKDAY.

Thanks so much,
Justin