I often compare sales data from the current year to the past year. When I do
this, I take the YTD figures and annualize using a constant. Each time I go
back I have to put in a new constant depending on the date.

Is there any kind of equation that will take a figure and annualize it based
on whatever day the file is open?
--
Julie