Almost. I'm trying to determine the average for the last seven days then take
that daily average and apply it to the remaining number of days in the month.
Lastly, the formula needs to add the determined daily average on top of what
has already been delivered. For example, today is the 26th so I need the
average from the 19th to the 25th. Once that is determined I need to assume
that average from now (26th) until EOM and it needs to be added on top of
what has already been actually delivered from the 1st to the 25th. That will
give me an overall pacing value for the month. Does that make sense?
--
Thank you for your help and support


"Sean Timmons" wrote:

I'm going to make an assumption here. Are you looking to determine the
average and sum from today to the end of the month?

If so, go to Tools Add Ins... Analysis Toolpak and use EOMONTH()


=(SUMIF(A:A,"=TODAY()-7",B:B)/COUNTIF(A:A,"=TODAY()-7")*(day(eomonth(today()))-day(today()))

should give average of last 7 days times number of days left in the month.

"Jacob Skaria" wrote:

Do you have a target for each month? OR if you want to keep pace with the
last 7 days average; then the average itself will be the daily target...

Am i missing something?

If this post helps click Yes
---------------
Jacob Skaria


"bbal20" wrote:

Hey Jacob. Thank you for the quick response. I think the formula may be
missing something. I may be wrong. How does this formula calculate the
pacing for the remaining days of the month? First the formula needs to figure
out the average for the last 7 days from TODAY() which it looks like you may
have done already, but we then have to take that average and apply it to the
remaining amount of days in the current month to figure out what I will
potentially end the month at. Any ideas?
--
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