date variable specifying last Wednesday

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)
 
Back
Top