Returning Wednesday's Date based on 2nd Date in the week.

[knobsdog]

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

[PhilipMannering · Accepted solution]

Hi @knobsdog 

You want to get the Wednesday of the week if I understand correctly? This should do the trick...

[knobsdog]

That's it, thank you so much for your help.