EXCEL COUNTING HELP

  • Thread starter EXCELably Challenged
  • Start date
E

EXCELably Challenged

I need to count the number of occurances of a date range from a column of
dates spanning from December 1, 2009 - March 15, 2010. (how many dates in
column C are in the month of december 2009). How do i write a formula that
will recogize the date? thanks
 
T

T. Valko

What version of Excel are you using?

Here's one way...

=SUMPRODUCT(--(TEXT(C2:C100,"m/yyyy")="12/2009"))
 
B

Bernd P

Hello,

=SUMPRODUCT(--(DATE(YEAR(A1:A10000),MONTH(A1:A10000),
1)=DATE(2010,12,1)))

Regards,
Bernd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top