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:
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.HTML Code:
Any help is appreciated. Thank you!
Bookmarks