Don I wrote:
I'm hoping someone can help me figure out a way to create an Excel
worksheet that will help me to keep track of my daily glucose logs and
give me the average of the last 7 days and for the last 30 days. As
time goes on, I'll add more columns to the excel sheet to represent
add'l dates.

The table below is meant to serve as an example of such an excel sheet
cells A2 and B2 are the cells I'm trying to put these averages in. If
today is 7/16/06, A2 should show the averages of cells D4 through
K10--but exclude from the average any EMPTY cells.

Hi Don,

Strange table...

In Excel we have letters for columns and numbers for rows, but your table
has letters for rows and numbers for columns...

You need just the AVERAGE function: just type (I'll use the references from
the table you linked, but they should not correspond to the real references
in Excel...) in A2:

=AVERAGE(D4:K10)

press Enter, select again A2 and drag the cell till A10. As you can see the
references will change in each cell.

The same is for a 30 days average.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy