Assuming your last row is 702 (assuming headers in row 1) with dates in Col A
and Value to average in Col B, enter this in C720
=Average(C338:C702)
You can copy this formula UP till row 366 or till you get a #REF error (when
you run out of 365 cells to average)

"Please help" wrote:


I have two years data in one excel spread sheet, I need to pull rollover
average for 365 days (from today until 1 year earlier exp 27-Apr-09 through
26-Apr-2008)

Can anyone help me please?