Prev: how to sum cells and ignore the #div/0! 's ?
Next: If Vlookup is error ( #NA)
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" <EXCELably Challenged(a)discussions.microsoft.com>
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" <EXCELably Challenged(a)discussions.microsoft.com>
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)