Is this possible?

[Huey462]

For the sake of argument, the user puts a date in cell A1. Is it possible to have Excel determine what the date for the Sunday of that week is? This may seem bizarre, but I’m building a fitness tracker for my workers over here and I have a calendar built with a lot of “=(cell)+1” to populate the dates.

 

[Michael M]

I think this is what you need

=A1-WEEKDAY(A1,1)+1

 

[Huey462]

Exactly what I needed.

Thank you