date formula - help

  • Thread starter Thread starter dmeconi
  • Start date Start date
D

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
 
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)
 
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)
 
try this for April
=SUMPRODUCT((MONTH(ChecksA)=4)*1)
this will sum the next column for April
=SUMPRODUCT((MONTH(ChecksA)=4)*checksB)
 
Back
Top