We have an access database with tables that have dates. The design view of these tables has date/time as the field type. I can use date functions on these dates and they work just fine. I import a table from access into excel. I delete all rows without a date. I create a pivot table from the data and it will not group on the dates. Tells me I can't group on that field. If I go back to the source table in excel and use date functions (i.e. month(StartDate) ) it works and returns the month - so excel is recognizing these as dates in the worksheet. Why not on the pivot table? I know this doesn't work if you have any blank date fields - and there are none. Any thoughts? Thank you. Marie