hmm.. ok thanks for that.. didn't thinka bout that... when i try the pivot table it uses each different date as an entry, how do i make the pivot table see everything in May as "may" and not individual dates....