I am trying to calculate the sum of a range of cells in Excel. I want the range to be from B3 to Bx where x is a changing value that corresponds to today's date, so that the sum changes each day automatically. How can I make a value x that corresponds to a certain value, and how do I put this inot the formula for the sum?
