Excel will do this for you automatically without converting your data.
See Pivot Table Grouping under help. Be sure when specifying your PT
data range that you have a valid date in every record. You won't get
the date group option if you have a record whose date field is a blank
or a non-date data type.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/