| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif function using dates
It worked! Thanks very much Pete.
"Pete_UK" wrote: Try it this way: =COUNTIF(M3:M158,"30/09/2007")- COUNTIF(M3:M158,"=01/11/2007") Hope this helps. Pete On Oct 12, 10:20 pm, Cassidy1 wrote: I want to calculate the number of entries in a column that are later than one date and earlier than another. This is what I thought would work, but doesn't: =COUNTIF(M3:M158,"30/09/2007"&"<01/11/2007") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif Function for dates in a range | Excel Worksheet Functions | |||
| A week of dates and counting them using the COUNTIF function with contingencies | Excel Worksheet Functions | |||
| CountIF with dates | Excel Discussion (Misc queries) | |||
| Need help on countif and sumif function with dates and wildcard characters | Excel Discussion (Misc queries) | |||
| COUNTIF using Dates | Excel Worksheet Functions | |||
Threaded Mode
