| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Function for dates in a range
I want to count a range of data if a cell in a range is within a date range.
I n others, If column D is a range of dates for a 12 month period, how can I count the # of dates tthat are in the date range 8-1-2007 through 8-31-2007? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Function for dates in a range
Try in say, E1:
=SUMPRODUCT(--(TEXT(D2:D100,"mmmyy")="Aug07")) Adapt the range to suit -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Mbanker" wrote: I want to count a range of data if a cell in a range is within a date range. I n others, If column D is a range of dates for a 12 month period, how can I count the # of dates tthat are in the date range 8-1-2007 through 8-31-2007? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Function for dates in a range
On Wed, 22 Aug 2007 14:28:00 -0700, Mbanker
wrote: I want to count a range of data if a cell in a range is within a date range. I n others, If column D is a range of dates for a 12 month period, how can I count the # of dates tthat are in the date range 8-1-2007 through 8-31-2007? =countif(d:d,"="&date(2007,8,1)) - countif(d:d,""&date(2007,8,31)) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A week of dates and counting them using the COUNTIF function with contingencies | Excel Worksheet Functions | |||
| Need help on countif and sumif function with dates and wildcard characters | Excel Discussion (Misc queries) | |||
| Excel COUNTIF Function - a range as criteria ? | Excel Worksheet Functions | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| CountIf Function - require range of criterea | Excel Worksheet Functions | |||
Hybrid Mode
