it seems simple, you can use =AVERAGE function to do this. see excel help for this function if you want detail.

Quote Originally Posted by kent
I am trying to keep a running average of daily calories used in a specific
period. For Instance taking the avg. of 5 days and be able to to automaticly
upate the running average on day6,7,8,9, etc