I have a worksheet with dates in row 1 and data values in rows 2 - 5. The data is then sub-totalled in row 6. The dates start from G1 and the date increases in the next column to the right. Currently this goes up to column EZ.
I want to get the sum of data from Row 6 for the last 7 days.
Today's date is in EZ1 so I have the following to get the first cell. =OFFSET(EZ1,,-7) I can sum the last week using: =SUM(EZ6:OFFSET(EZ6,,-7))
But how can I get this to update automatically so that I the value is always the most recent?