I have dates in col. 1 and projected sales in col. 2. I'm trying to create a dynamic formula that adds the next 7 days of projected sales together based on the current date/value for "Today". Can you please advise? Not sure of easiest way to do this.
Bookmarks