I am trying to create a series of one of my criteria to copy across the rows of my spreadsheet. The criteria is a date range. I am currently manually modifying the formula to change the date for each column.
This is the formula in C13
The highlighted part, I change in each column to make the range summed one month. Is there a way I can make this a series, so I can just drag it across the row?
Here is a screenshot of my spreadsheet.