In row 3710, column G, I have this formula: =IF(A3710=TODAY(),E3710,"")
Column H is the last column in the sheet that contains data. However, in column H, row 3710, this formula appears: =IF(A3709=TODAY(),SUM(G$2:G3709),"")
For some reason, the row number does not advance to G3710, it reads...