Have you considered a Pivot Table?

DataPivot Table
Use Excel
Select your data
Click the [Layout] button

ROW: Drag the Names field here
DATA: Drag the Dates field here
If it doesn't list as Count of Dates...dbl-click it and set it to Count
Click [OK]
Select where you want the Pivot Table...and you're done!

That will list each name and the count of dates.

To refresh the Pivot Table, just right click it and select Refresh Data.

Something you can use?

***********
Regards,
Ron


"Mandeep Dhami" wrote:

Hi,

I have a database where in dates are repeated in column D and names in
column I.
I want a formula in a different worksheet of the same file wherein I get the
count of dates column along with the individual name.
The intention is to get number of days each individual is present. The same
dates could be repeated any number of times for the same individual.

Example for the month of Dec. 2005
Dates Names
20 AD
15 BC
08 GH........etc

Cheers,
Mandeep Dhami