| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count instances of text in date entries
I'm using Excel 2007. I have a column of dates in this format - 04-Aug-08,
15-Jul-08, etc. I would like to count the number of times a certain month shows up in the column, i.e. how many of the dates in the column are in Aug, how many in Jul, etc. I've tried: =COUNTIF(B4:B40,"Aug") =COUNTIF(B4:B40,"*Aug*") =COUNTIF(B4:B40,"-Aug-") none of these formulas works. Please help. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Instances of Text in String Q | Excel Worksheet Functions | |||
| Count Multiple Instances of Text in a Cell | Excel Discussion (Misc queries) | |||
| Count Multiple Instances of Text in a Cell | Excel Discussion (Misc queries) | |||
| Count Multiple Instances of Text in a Cell | Excel Discussion (Misc queries) | |||
| Count Multiple Instances of Text in a Cell | Excel Discussion (Misc queries) | |||
Threaded Mode
