Forum Discussion
filter date bounded between two ranges
I am using google sheets How to use the filter function to filter date bounded between two ranges and sum horizontally these values, see attached file.
To filter the data, you can use the formula
=FILTER(B7:J12,B7:J7>=D6,B7:J7<=G6)
I wouldn't place SUM formulas to the right of the output range since the width of the output is variable.
Same Problem I have when applying on Google Sheets. Just displaying the dates without underlying cells values