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
|