| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
tally a range of dates
=SUMPRODUCT(--(MONTH(C8:C78)=4))
"Maistrye" wrote: Sher Wrote: I have a range of dates on a worksheet that I want to tally for each month. I have used =COUNTIF(C8:C78,"4/1/06") (this works only for 4/1/06), but my date range is from 4/1/06-4/30/06, Any ideas Perhaps = COUNTIF(C8:C78,"<5/1/06") - COUNTIF(C8:C78,"<4/1/06") HTH, Scott -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=563410 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible to chart data for dates implicit within a range? | Charts and Charting in Excel | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Identifying Overlapping Dates within a range | Excel Worksheet Functions | |||
| count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Hybrid Mode
