| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of events in a year
I have a list of fire events that I need to sort by year. The date field for
each event is formated as mm-dd-yyyy. I can't figure out how to restrict the count function to just pick up the year. The data spans 40 years so I don't want to have to write out 40 different date range functions. Any suggestions? I thought this would be easier.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Weeks in a year | Excel Worksheet Functions | |||
| Age calculator and Total number of year counting | Excel Discussion (Misc queries) | |||
| How do I count the number of events in a 90 day period? | Excel Worksheet Functions | |||
| Counting events since last occurences | Excel Worksheet Functions | |||
| Counting the events | Excel Worksheet Functions | |||
Threaded Mode
