M
Michael McClellan
I have a column of dates and want to know how many dates are in March.
How can I get excel to count them for me?
How can I get excel to count them for me?
P
Peo Sjoblom
Use this instead
=SUMPRODUCT(--(MONTH(A4:A40)=3))
if you insist using dcount
use a criteria like
=MONTH(A4)=3
where A4 is the first cell in the table with dates
assume you would put that in D2
leave D1 blank and use
=DCOUNT(A3:A40,"Dates",D1
2)
--
For everyone's benefit keep the discussion in the newsgroup.
Regards,
Peo Sjoblom
=SUMPRODUCT(--(MONTH(A4:A40)=3))
if you insist using dcount
use a criteria like
=MONTH(A4)=3
where A4 is the first cell in the table with dates
assume you would put that in D2
leave D1 blank and use
=DCOUNT(A3:A40,"Dates",D1
2)--
For everyone's benefit keep the discussion in the newsgroup.
Regards,
Peo Sjoblom