What you just stated is correct. To make myself clear,
I would need the data for the following:
July 28, July 29, July 30, July 31,....Aug 4. Then
Tomorrow's data would be from July 29..............Aug 5.

"T. Valko" wrote in message
...
Not sure what the significance of today's date has to do with it.

If you enter data daily then from tomorrows date to the end of the month
there will be no data. Is that correct? If so, then don't you just need
the *last* 8 entries in the row? Also, today's date is 8/4 so there aren't
8 entries for the month, right?

--
Biff
Microsoft Excel MVP


"kcholly" wrote in message
...
I have cols. for each day of the month starting with the 1st.. In col A
is
the grand total of the last 8 days of data. How would I create a formula
to
add the last 8 days of data automaticlly from todays date.
Ex. Col A...Col B........Col M
69 12 8.... 11