Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet that has one named range 'DATE' which contains a date
in the format 01-MAR-05. I have a summary sheet that I have each month listed in 12 cells (Jan to Dec). I want to read the DATE range, and count the number of occurances which fall into each month. Is this possible with a Excel funtion, or mixture of functions, or do I need to write my own? Thanks for any help. Regards Chris Darlington |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
counting number of particular items in a list | Excel Discussion (Misc queries) | |||
how to get week number in month in excel ? | Charts and Charting in Excel | |||
GET.CELL | Excel Worksheet Functions | |||
calculate month from week number | Excel Worksheet Functions |