You probably heard this a hundred times already or at least a variation of, but I need a formula to find the date 2 Wednesdays ago no matter what day of the week you are currently on. In other words today is the 28th, so I need a formula to give me the 19th. If it was the 26th, I would want 2 Wednesdays ago so that would be the 12th. Does anyone have a formula for this?