Return the date of the 1st Friday before a specified date

[DMP3]

I am trying to retrieve the date of the 1st Friday before another specified date. Any assistance is once again much appreciated.

example:

cell P2 = 3/11/2011
cell P3 = 3/19/2011

In both B2 & B3 I would like to see "3/11/2011" and always have that value each time I open the file for each work day for 1 week.

So yesterday (Monday March 14th) I had the below formula in B2 & B3 and it worked (yesterday it returned "3/11/2011"):

=WORKDAY(TODAY(),-1)

However when I open the file today (Tuesday March 15th) the formula returns "3/14/11". I know this formula works like it suppose to but I really do not want the date of the previous workday, but rather the date of the previous Friday.

Thank you again!

 

[barry houdini]

What should it show on a Friday, that date or the week before?

For the former

=TODAY()-WEEKDAY(TODAY()+2)+1

or the latter

=TODAY()-WEEKDAY(TODAY()+1)

 

[DMP3]

Thank you - that works