Dcount - using with dates

  • Thread starter Michael McClellan
  • Start date
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?
 
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:D2)



--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Top