How to calculate an average over time

[MossbackGus]

I am wondering if you can calculate an average over time? By this I mean if I wanted to know an average of a number at the end of each business day for a period of time but that average was from a set start date through the current day. Then, "tomorrow", it would add another day giving a new average.

EXAMPLE:
$1000.00 is the total start March 5 and it is now March 16. There were 10 business days during that period so the average would be $100.00. Now another business day has come and gone, the total is now $1100.00 but there are 11 business days so the average remains $100.00.

Basically I want the formula to add a business day at close of business each day. Can there be a formula that is smart like that?

Hope this makes sense and thanks in advance.

 

[arthurbr]

Hi


try the AVERAGEIFS function using your start date as first argument and TODAY() as second argument. The syntax can be found on the Net

 

[MossbackGus]

Thank you very much, this was helpful but I am still sorta stuck. I apologize, I am not very proficient with EXCEL. Is there a way you can show me the formula so I can copy it for my purposes?

Hi


try the AVERAGEIFS function using your start date as first argument and TODAY() as second argument. The syntax can be found on the Net