Reply to thread

Message: [QUOTE="Roger Govier, post: 2892457"] Hi Julie How is your previous year's data held? If you have a collection of sales with all of their individual dates, then it would be easy enough to use Sumproduct for the range of dates that corresponds to this year's year to date. You would then have a like for like period comparison of actual data. If you are adjusting this year's figures to scale them up to a full year, are you just multiplying this year's figures by a ratio of Year/Year to date? If so, then the multiplication factor would just need to be set to =1/((TODAY()-yearstart)/(EOMONTH(yearstart,11)-yearstart)) provided your yearstart is the first day of a month. If it isn't post back and the formula can be amended. EOMONTH is a feature from the Analysis Toolpack Tools>Addins>Analysis Toolpak Regards Roger Govier [/QUOTE]