I have a field, Anchor Date, where every week I manually change the date to the most recent Sunday. Can I write a formula to do this dynamically? Sometimes I run the report on Monday, and sometimes I run it on Tuesday, so I can't use a formula that just uses -1 day or -2 days. It has to be the most recent Sunday (or the date of the start of the week if the start of the week is set to Sunday).
