ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   EXCEL COUNTING HELP (https://www.excelbanter.com/excel-worksheet-functions/258980-excel-counting-help.html)

EXCELably Challenged

EXCEL COUNTING HELP
 
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. Valko

EXCEL COUNTING HELP
 
What version of Excel are you using?

Here's one way...

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

--
Biff
Microsoft Excel MVP


"EXCELably Challenged" <EXCELably
wrote in message ...
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




Bob Phillips[_4_]

EXCEL COUNTING HELP
 
=COUNTIF(A:A,"="&DATE(2010,01,01))-COUNTIF(A:A,"="&DATE(2009,12,01))

--

HTH

Bob

"EXCELably Challenged" <EXCELably
wrote in message ...
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




Bernd P

EXCEL COUNTING HELP
 
Hello,

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

Regards,
Bernd


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com