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:
HTML Code:
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!