I have a data file that has news rows added to it every day. I want to be able to sum the seven rows of data automatically, so only the last seven days of data are used in my calculations. Is this possible?

Also, I have another data sheet that has multiple enteries per day. Is it possible to only sum the last 7 days of data. There are more than seven rows of data but only for seven days. Thanks for the help.