excel moving average
 

Need to calculate six month moving avaerage based on =now() and batabase
function daverage

Use two criteria cells one is =""&NOW()-180 and the other is "<"&NOW().

This will give you the average of everything between now and six months ago.
You can change 180 to whatever you want if that's not exact enough for your
needs.

"edba" wrote:

Need to calculate six month moving avaerage based on =now() and batabase
function daverage

Works great! I really appreciate the help. I forgot the quotation marks
around the greater sign. I ended up replacing the now() functionin your
equation with a cell reference. That allows the user to change the function
"now()-180" without messing around with the criteria that I like to keep
hidden when possible.

"JBoulton" wrote:

Use two criteria cells one is =""&NOW()-180 and the other is "<"&NOW().

This will give you the average of everything between now and six months ago.
You can change 180 to whatever you want if that's not exact enough for your
needs.

"edba" wrote:

Need to calculate six month moving avaerage based on =now() and batabase
function daverage