Here's what I'm trying to do.
I have rows of data that have a date associated with them.
I want to be able to enter a date range in my spreadsheet and for a cell with a formula to determine based on those dates which cells to use in its calculations.
The way I do it now is to manually look at the data. I see that for example Feb 1st through Feb 15th is in cells B100 through B155. Then I manually change the formula to look at cells B100 through B155. The next day I have to change the formula again to look at 2/2 through 2/16 etc...
Bookmarks