| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting multiple dates in a range
I need to count the number of occurences of a range of dates eg from 1st to
31st of a given month OR set a criteria to count the occurences between 2 dates eg 1/3/08 to 7/3/08 inclusive. The named range is set to presentations and i have tried countif/sumif and conditional sum wizard yet to no avail. What I have come close with, but still gives a wrong answer: =COUNTIF(Presentations,AND("="&"01 Mar 08","<="&"31 Mar 08")) any help appreciated (dates are dd/mm/yy in Australia) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Empty Dates within a Range? | Excel Worksheet Functions | |||
| Counting dates within a specified range | Excel Discussion (Misc queries) | |||
| counting valid dates in a range of cells | Excel Worksheet Functions | |||
| Counting dates in a RANGE (yargh!) :) | Excel Worksheet Functions | |||
| Counting Dates in a Range | Excel Discussion (Misc queries) | |||
Threaded Mode
