Date driven value

[ronocoo]

I need help coming up with a formula that will make a fixed value appear if a specific date falls on or before the Friday of that week.

For example:

May 23, 2011    May 27, 2011    June 3, 2011    June 10, 2011    June 17, 2011
Current Week    One Week Out    Two Weeks Out    Three Weeks Out    Four Weeks Out
                  X             

The dates that appear other than current week are Fridays. For a fixed payment on the 25th, I'd like a formula that would make that value appear on the May 27. It doesn't need to be complicated. I plan on referencing this formula to for all the weeks because the week out dates are driven by the current week.



Any help is appreciated. Thank you!