If Statement

[eramirez148]

How can I make a cell read from Wednesday to Wednesday from todays date.
For example once cell will show todays dates. Let's say today is Tuesday 08/20/2024 the the next cell should read the Wednesday prior 08/14/2024. Once today's date hits the Wednesday of the week lest say 08/21/2024, then the next cell should read that Wednesday 08/21/2024 as well. See examples below.

Todays Date	Tuesday, August 20, 2024​
Current OSD	Wednesday, August 14, 2024​

Todays Date	Wednesday, August 21, 2024​
Current OSD	Wednesday, August 21, 2024​

 

[6StringJazzer]

Use the formula below. It does not incorporate today's date but it refers to the cell with today's date. You could directly use TODAY() in the formula if you prefer.

$scratch.xlsm
	A	B
1	Today's Date	Tuesday, August 20, 2024
2	Current or prior Wednesday	Wednesday, August 14, 2024
Sheet2

Cell Formulas
Range	Formula
B2	B2	=B1-WEEKDAY(B1,13)+1

Here's what it will look like tomorrow:

$scratch.xlsm
	A	B
1	Today's Date	Wednesday, August 21, 2024
2	Current or prior Wednesday	Wednesday, August 21, 2024
Sheet2

Cell Formulas
Range	Formula
B2	B2	=B1-WEEKDAY(B1,13)+1