Correctly Identify Seasons

Giganews Newsgroups
Subject: Correctly Identify Seasons
Posted by:  iamnu (iamnu…@gmail.com)
Date: Sun, 20 Jul 2008

I have a spread sheet that has daily weather information.

I have a column "Seasons" that specifies if the date is "Summer",
"Fall", "Winter" or "Spring".

Since Winter begins on ~December 21 and ends on ~March 21, my Pivot
Table is showing the wrong information for "Winter", because it is not
using December values from the previous year.

Can someone give me a suggestion as to how to "fix" my spreadsheet to
properly display the "Seasons" information in a pivot table?

Replies