I am using an offset function to sum a range of cells as follows
=SUM(OFFSET(Days!A13,0,8,21,1)) and this works fine
My issue is the starting cell can vary as this references the first Monday of the month. I can find the first Monday of the month in a range cells from A10 to A31 use an if statement and dropping the cell reference into another cell say A1 using the following CELL("address",Days!A13) so A1 now has Days!$A$13 in it.
When I try to do the following and replace the Days!A13 with CELL("contents",$A$1) in the Offset function so looks like this
Excel comes up with an error and wont even accept the formula.