Posted to microsoft.public.excel.newusers

George Gee George Gee is offline

external usenet poster

Posts: 109

Count occurrences of dates

Column A is a list of dates with the format 01/01/2000, 30/04/2001 etc.
How would I count the number of occurrences of dates in column A
for the month of say January 2000

How would I count the number of occurrences of dates for the year 2000

Great If you can help.

George Gee

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Unique Occurrences	Brandon G.	Excel Worksheet Functions	3	August 12th 08 12:43 PM
How do I count repeat Occurrences	kevhatch	Excel Discussion (Misc queries)	5	May 25th 08 02:49 AM
formula to count occurrences	Libby	Excel Worksheet Functions	5	March 28th 08 06:07 PM
trying to COUNT occurrences when certain criteria is met	Allan from Melbourne	Excel Discussion (Misc queries)	4	August 2nd 06 11:01 AM
Count unique occurrences of name	jhicsupt	Excel Discussion (Misc queries)	4	October 5th 05 05:46 PM

All times are GMT +1. The time now is 07:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us