View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Rolling date looking 30 Days past

I'm logging data into a spreadsheet daily and keeping track of a rolling 30
days average and 1 std dev above the average. How do I easily create a way
to update this everyday without changing the formula every day? I have dates
on the left and numbers (25, 32, 28, etc.) next to the date. Thanks.