For reference, the previously accepted answer wrongly outputs future date for some scenarios

This formula outputs the **previous Wednesday**.

```
=TODAY()-MOD(WEEKDAY(TODAY())+2,7)-1
```

If today is Wednesday, it outputs the previous Wednesday as well.

`MOD(..., 7)`

always returns value from 0 to 6.

So, `-MOD(...)-1`

always subtracts a value of 1 to 7 (days) from `TODAY()`

.

(You can adjust the value `+2`

in the formula to get different weekdays)

Example:

- Today is
`2019-2-25 (Mon)`

, outputs `2019-2-20 (Wed)`

- Today is
`2019-2-26 (Tue)`

, outputs `2019-2-20 (Wed)`

- Today is
`2019-2-27 (Wed)`

, outputs `2019-2-20 (Wed)`

- Today is
`2019-2-28 (Thu)`

, outputs `2019-2-27 (Wed)`