Hi,
can anybody advise of a formula to work out an average on a given number on
the days passed in the month.....??
eg
data below for first 5 days of month
day1,20
day2,25
day3,32
day4,10
day5,9
so the average thus far in the month will be 19.2 (first 5days data divided
by 5)

if days 6 and 7 are added the formula would then work out the average for
the first 7 days.....and so on
hope thats clear
thanks