Pivot Table

[Nick Hodge]

I would suspect that the dates are formatted in the source as text or that
there are spaces which Excel can't coerce to dates. Go to your source data
and check they are truly dates with no spaces in the fields

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[jjk2000]

I can't manage to amalgamate date entries into my pivot table by month
I tried the group option but it simply put the entries into random groups.

 

[dbahooker]

Excel doesn't have adequate datatype validation.

use a tool with real datatype validation.. like a database for example

-Aaron