I'm new to this forum although I have been lurking for some time.
I've been using Hazel for some time and it is a great piece of software that I use religiously for automating my filing.
I'm not too sure why the image below is cropped on the right, but as it happens I hope it will still allow the help I require.

'The current date' in the pattern choices is my issue.
I know I can default that date to plus or minus days, but what I'm looking to achieve is as follows:
I want that date to always be a Wednesday. I always execute Hazel 75% of the time on a Thursday so the minus 1 day setting works most of the time. However it's the 25% I need help with.
Basically If I execute Hazel on a Fri-Tue I want the chosen date to be the upcoming Wed, if it run on a Wed I want it to be the same day, and if run on a Thursday I want it to be minus 1 day.
Hopefully I have explained myself properly and I am sure this could be done.
As a starting point I tried to see if I could get this done in Excel and I couldn't, so I'm quite stumped.
All help/guidance would be thoroughly appreciated.