Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to count the number of occurences of a text item within a date
range. I have tried using the COUNTIF function, but since my date is in DD/MM/YYYY format I am unable to single out the year (ex "2004"). Example, total number of Safety Classes in 2004 - with one column as the date and another column listing the safety class. I can count the total number of occurences of the safety class, I'm just having issues coordinating it with a date range. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
adding occurrences for date range | Excel Discussion (Misc queries) | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |