I'm using a formula that checks if a day falls between 2 dates that is listed in another sheet.
These dates are listed in 2 columns: B and C
The dates run down 10 rows each time, after which a 5 row break is in place before the next sequence begins
The problem is that I can't drag my formula down the normal way, because it just adds +1 row.
I've read about using "OFFSET", but I can't figure out how to add this to my formula.
In my case the next row should add "+14" to all values in B and C column.
The formula I'm using is:
The formula on the following row should be:
I've attached an example with what I would like to accomplish. I just don't want to manually change all the formulas all the way down 135 rows.
Any help is much appreciated.
Bookmarks