Count number of cells of a particular month in a column of dates
Gohan51D wrote:
Cells D2-D15 contains a list of dates ranging from Jan through May. I
need D16 to count how many cells in that column contain dates in
March. I am assuming it is a COUNTIF function but I have not been
able to find a solution in any texts or on the internet. Any type of
help is appreciated.
Gohan51D
=SUMPRODUCT((MONTH(D2:D15)=3)*1)
|