date formula - help

[dmeconi]

How do I write a formula to recognize the month in a date.
I have a list of dates in a spreadsheet and want to count
the number of dates in a collum related to "January, Feb,
March etc. I need to know how many of each month. Any
assistance would be appreciated

 

[Nikos Yannacopoulos]

Assuming your date is in cell C1, enter the following
formula in another cell:
=MONTH(C1)
and copy down.

Nikos Y. (nyannaco at in dot gr)

 

[Arvi Laanemets]

Hi

With dates p.e. in range A2:A1000 or less and the month name you are
searching for in C2
=SUMPRODUCT((A2:A1000>0)*(TEXT(A2:A1000,"mmmm")=C2)*1)
or with month written directly into formula
=SUMPRODUCT((A2:A1000>0)*(TEXT(A2:A1000,"mmmm")="January")*1)

 

[Don Guillett]

try this for April
=SUMPRODUCT((MONTH(ChecksA)=4)*1)
this will sum the next column for April
=SUMPRODUCT((MONTH(ChecksA)=4)*checksB)