Put this formula in A3 and copy down the column.

=IF(WEEKDAY(A2)=2,A2-3,A2-2)

--
Carlos

"JR" wrote in message
...
Good Morning Excel Masters,

I would like to ask for help.

I have a report where I have to show only Monday, Wednesday and Friday
dates. I need to go backwards starting with today's date. So for example
in
A2 I will put =today().

However in A3 I need the formula to show the date for the previous
Wednesday
(3/22). Now writing this is generally easy, however when Monday (3/27)
comes
around I will need A3 to show the date for Friday (3/24), and then A4 will
need to show Wednesday's date (3/22) etc.

Your help is appreciated.

JR