Format your dates as YYYYMMDD in your SQL (assuming you can edit it -
I recall that you can). That will make it so that when you create a
pivot table where the data covers more than one calendar year that the
columns will end up in the right place. Also, Excel can do strange
things with date formatting. I for get the exact example, but
something like "1-10" always assumes the current year. YYYYMMDD will
resolve that issue too.