What is a helper column? The date column is not arranged chronologically &
is about 50 percent blank.
=MONTH(A2)
=YEAR(A2)
Just gives me the year & month entered in the respective cells but doesnt
count anything. Could I have the cells formatted incorrectly?



"Bob Phillips" wrote:

Create a helper column and add the year there
=YEAR(A2)
and another with the month
=MONTH(A2)

and then create a pivot table for all of it. Probably simpler than trying to
build yourself.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Di" wrote in message
...
I have a column with over 11(K) date entries. This column grows daily. I
need a formula that will total the number of entries by month & year
(disregarding the day).