Looking for an assumptively simple formula, but I can't seem to figure it out. I want to place a "live overview pane" in a financial report (columns A&B).
The yellow B3 needs to show the current capital (green) - per week (purple).
For instance: It's Sunday, December 15th. B3 tells me whatever has been calculated in D14. The next Monday, starting a new week, I want B3 showcasing whatever is calculated in F14.
I've fiddled with the =(WEEKNUMBER()) options and read a lot of threads here, but am not achieving my goal through this.
Thanks in advance.
Bookmarks