Thread: totalling dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default totalling dates

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.