Last 7 days
Most certainly. I may have misspoke when saying I needed the Now(). The
formuls would probably need to use the TODAY() function. That is needed to
get the average of the last 7 days I would imagine. Something like TODAY()-7.
I'm basically trying to calculate the average amount of impressions over the
last 7 days to calculate the pacing rate if I were to maintain that average
each day for the remainder of the month. I hope that makes sence. Let me know.
--
Thank you for your help and support
"bbal20" wrote:
I am trying to calculate pacing based on the last 7 day average. My dataset
looks as follows:
Date Impressions
5/1/2009 4,562,077
5/2/2009 4,433,984
5/3/2009 4,340,952
5/4/2009 6,174,786
5/5/2009 6,736,687
5/6/2009 7,360,844
5/7/2009 6,576,612
5/8/2009 5,030,927
5/9/2009 3,702,990
5/10/2009 4,016,134
5/11/2009 5,894,572
Does anyone know how to construct a formula that always takes an average of
the last 7 days for the "impression" column based on the Now() date and how
many days are left in the month.
--
Thank you for your help and support
|