Finding the Date of the Most Recent Sunday Past

To find the date of the most recent Sunday past, follow these steps:

1. In a blank cell, enter the following formula:
   Formula:

   =TODAY()-WEEKDAY(TODAY(),2)+1 

2. Press Enter. This will give you the date of the most recent Sunday past.
3. You can now use this date to display data for the week ending on that Sunday.

For example, if today is October 12, 2021, the formula will return October 10, 2021, which is the most recent Sunday past. You can then use this date to display data for the week ending on October 10, 2021.