MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can I automatically add the last 30 days of a row?


Posted by Frank on November 13, 2001 8:51 PM

I have a spreadsheet that needs to add the last 30 days of a row. How can I set it up to automatically add the contents of the cells of the last 30 days? It needs to automatically update on a daily basis and give the sum of only the last 30 days.


Posted by Barrie Davidson on November 13, 2001 9:42 PM

Frank, can you clarify this? Where is your data? What is the data range? What is the data table's elements (how is it laid out)? How do you determine the last 30 days, based on the system date or on a date input in a cell?

BarrieBarrie Davidson