date variable specifying last Wednesday

P

Philly

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.
 
R

Rick Brandt

Philly said:
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.
Click to expand...

Try...

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