Use

=COUNT(A:A)

If this post helps click Yes
---------------
Jacob Skaria


"Deb" wrote:

Hi Jacob

The dates are all different. What I need to is to be able to know how many
cells have dates in.

"Jacob Skaria" wrote:

Hope the dates are formatted to excel date format. IF so

=COUNTIF(A:A,DATE(2009,6,10))
will give you the number of dates with 6th June 2009 in Column A

=COUNTIF(A:A,"Y")
will give you the number of Y's in Column A

--
If this post helps click Yes
---------------
Jacob Skaria


"Deb" wrote:

Hi all - I have a column which can include a date (eg format 10 June 2009)
and I want to be able to count the total number of times a date appears in
that column. I also have another column which includes the letter 'y' in
some cells. I also wish to count the total number of 'y's. Can anyone help.
As you can read I am so rubbish at that it is pitiful! Deb