I need assistance in creating the formula to select one week ago Wednesday
through Thursday of the current week. This query needs the ability to be run
on any day of the week. Below is the formula I have in place but it returns 8
days ago through yesterday. If this is run on Wednesday it works correctly
but I need it to be run on any weekday.

=Date()-Weekday(Date())-2+1*(Weekday(Date())=4) And =Date()-Weekday(Date())+3+1*(Weekday(Date())=1)

--
Rick