Posted to microsoft.public.excel.misc

jwmillzy

Posts: n/a

using countif to add dates

I need to count the number of events in a month.
I am reading off a column of cells that have 5/1/2006,
5/11/2006, 4/27/2006, etc
I want to tally the number of events, so in the above example
the result would be May 2 and April 1
I need it to count all dates in may as one total, April as a total etc
I am having trouble because my formula will only recognize each unique date
Any suggestions, thx

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
countif non blank cells + dates overdue	mcmillad	Excel Worksheet Functions	1	April 19th 06 01:47 PM
Countif on multiple dates	Jim	Excel Worksheet Functions	6	December 13th 05 05:56 PM
COUNTIF using Dates	WLMPilot	Excel Worksheet Functions	1	October 7th 05 12:51 AM
Countif using dates	Bugaglugs	Excel Worksheet Functions	11	August 23rd 05 05:16 PM
COUNTIF With Multiple Dates, Columns and Text	Shannon	Excel Worksheet Functions	4	November 26th 04 11:12 PM

All times are GMT +1. The time now is 08:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us