With a valid date in A2, another option for A3 might be:

=A2-MOD(128,WEEKDAY(A2)+3)

and copy down.
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"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