| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countifs with multiple dates
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 | |||
| Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr | Excel Worksheet Functions | |||
| countifs Text and Dates | Excel Worksheet Functions | |||
| Countifs and multiple columns... | Excel Worksheet Functions | |||
| Multiple countifs | Excel Worksheet Functions | |||
| COUNTIFs with multiple criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
