Function needed!

[dwboiler]

I need a function that will search a column of dates and count th
number of occurances in each month so I can graph the number of record
by month.

My first problem is seperating months using serial numbers, and m
second problem is finding a function that will count based on specia
criteria. Any help would be greatly appreciated.

Thanks

d

 

[JulieD]

Hi

one way

=SUMPRODUCT((TEXT(range_dates,"mmm")="Jan")*1)

where range_dates is the range of cells that you want to look through to see
if they are in Jan

hope this helps
Cheers
JulieD

 

[Ron Rosenfeld]

I need a function that will search a column of dates and count the
number of occurances in each month so I can graph the number of records
by month.

My first problem is seperating months using serial numbers, and my
second problem is finding a function that will count based on special
criteria. Any help would be greatly appreciated.

Thanks

dw

The Pivot Chart and Table wizard would allow you to group your entries by
month, do a count of the number of entries in each month, and graph the
results.


--ron