|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 15th, 2010, 08:32 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
March 15th, 2010, 09:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
March 15th, 2010, 09:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#4
March 15th, 2010, 09:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL COUNTING HELP
Hello,
=SUMPRODUCT(--(DATE(YEAR(A1:A10000),MONTH(A1:A10000), 1)=DATE(2010,12,1))) Regards, Bernd
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
