date variable specifying last Wednesday

[Guest]

Hello,

I am trying to make a variable that reflects the date of the previous
Wednesday relative to the current date. Is there a way I can do this?

Thank you for your help.

 

[Rick Brandt]

Hello,

I am trying to make a variable that reflects the date of the previous
Wednesday relative to the current date. Is there a way I can do this?

Thank you for your help.

Try...

Date()-Weekday(Date(), vbThursday)