I have a question that revolves around pulling back the date of Wednesday of a date in the same week. So for instance if the Completed Date is 4/20/2023 it would bring back a Batch Date of 4/19/2023, if the Completed Date is 4/25/2023 it would bring back 4/26/2023. I'm using Monday as day 1 and tried creating week numbers to compare my Completed Date week # and the current week # but it's not working. Any help would be greatly appreciated.
| Completed Date | Should show Batch Date |
| 4/25/2023 | 4/26/2023 |
| 5/2/2023 | 5/3/2023 |
| 5/4/2023 | 5/3/2023 |
