I had the below with "=4" and it should have been "=4".

--
Rick


"rbeach" wrote:

My apologies but I stated "one week ago Wednesday through Thursday" below but
it should read "one week ago Wednesday through Tuesday".
--
Rick


"rbeach" wrote:

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