Robin

Posts: n/a

Counting individual dates

I have a column of dates, some dates are repeated, and I would like a count
of the number of separate dates.

My sample column:
1/1/05
1/1/05
1/2/05

I want my return to be 2, because I have 2 different dates.

Is there a way to do this?

Thanx!

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
Counting dates in a column	Robb27	Excel Worksheet Functions	4	May 25th 05 09:31 AM
Counting Dates	MJMP	Excel Worksheet Functions	2	May 24th 05 07:34 PM
Counting occurences of a specific day between two dates	coal_miner	Excel Worksheet Functions	1	April 20th 05 03:37 PM
How to Calculate Dates without counting the weekends	Lillian F	Excel Worksheet Functions	9	January 24th 05 09:09 AM
counting entries between two dates?	Todd	Excel Worksheet Functions	7	November 1st 04 11:07 PM

All times are GMT +1. The time now is 02:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us