Assuming the dates are in say column A and the amounts in B, you can do a
running average with

C2: =AVERAGE($B$2:B2)

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"onyx4813" wrote in
message ...

What formula do I use to calculate a weekly average as the monthly total
changes?
Example: july total value divided by 28weeks, august value divided by
32 weeks, sept value divided by 36 weeks and so on
In other words, a weekly average as each month ends and the value is
entered
I hope someone understands this and can help
thanks so much
leslie


--
onyx4813
------------------------------------------------------------------------
onyx4813's Profile:
http://www.excelforum.com/member.php...o&userid=26305
View this thread: http://www.excelforum.com/showthread...hreadid=471373