Thank-you for your response. I received two responses, so I'll just repeat
to you what I did to him. I'm not sure how I'm supposed to do this. Anyway:

The data comes from our company accounting
system that changes by the minute. I run a query for Year to date parts
sales by customer and the data that is dumped into excel is every part that
has been sold to each customer YTD up to that moment. When running the
report today, I multiply every YTD sales figure by the constant 1.064 which I
calculate by dividing 365 by 343, which is the number of days of sales that
YTD represents. If I were to run the report on July 1, I would multiply by
2, etc.

--
Julie


"Dave O" wrote:

Yes, most likely: what is your formula? Please post it, and we can
figure out how to make it dynamic for your application.