Thread: totalling dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
manish[_2_] manish[_2_] is offline
external usenet poster
 
Posts: 3
Default totalling dates

On Feb 23, 6:28 pm, Gary''s Student
wrote:
Lets say we have a list of dates in column A. In an unused column enter:
=COUNTIF(A:A,A1)
and copy down. This helper column will tell you how many times each date
apears in column A.

You can also use this formula in Conditional formatting.

--
Gary's Student
gsnu200707

"manish" wrote:
Hi All,


How could i count the number of identical dates in a column ?


Thanks in advance.


Rgds,
Msh.


Thanks gary and darlove .. both of you solved my problem . Thanks a
lot.