From: EXCELably Challenged EXCELably on 15 Mar 2010 16:32 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 From: T. Valko on 15 Mar 2010 17:03 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" wrote in message news:B971F8BC-3169-4623-9B06-604C979D9975(a)microsoft.com...>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 From: Bob Phillips on 15 Mar 2010 17:21 =COUNTIF(A:A,">="&DATE(2010,01,01))-COUNTIF(A:A,">="&DATE(2009,12,01)) -- HTH Bob "EXCELably Challenged" wrote in message news:B971F8BC-3169-4623-9B06-604C979D9975(a)microsoft.com...>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 From: Bernd P on 15 Mar 2010 17:26 Hello, =SUMPRODUCT(--(DATE(YEAR(A1:A10000),MONTH(A1:A10000), 1)=DATE(2010,12,1))) Regards, Bernd  |  Pages: 1 Prev: how to sum cells and ignore the #div/0! 's ?Next: If Vlookup is error ( #NA)