March 3, 2011 1 Comment
In my last post, Showing Activity for Most Recent Days, I showed you how to find the most recent date for which you have “totals” data. We found that whether it’s support calls or sales made each day, being able to retrieve this information quickly and efficiently can be extremely helpful. By using the ROUNDDOWN AND MAX functions, as well as the very powerful SUMPRODUCT, we were able to create a quick summary of the most recent days’ activity. The obvious next question? How do those days compare with the same time last year. In other words, using the most recent data, how are things going compared to last year?
We already have the first several pieces of the puzzle, the current year’s sales information. To compare the data to last year, we simply find the totals for the same dates in the previous year. We can determine these dates these dates fairly easy by using the CONCATENATE formula, along with the popular and well known MONTH and YEAR formulas. Read more of this post