![]() |
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 |
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 |
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 |
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