Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel moving average
Need to calculate six month moving avaerage based on =now() and batabase
function daverage |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Moving blocks of data in excel | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |