If those times are really just times (and not date-times), then you
could use this formula:

=COUNTIF(A:A,"1")

assuming the data is in column A - put the formula in a different
column. This will give you an overall count of the dates - not sure
what you mean by "count (month-wise)".

Hope this helps.

Pete

On Nov 1, 9:12 am, Pankaj Trivedi
wrote:
Hi,

I have been a user who have always done simple tasks like creating
table, formatting etc in Excel. But time requires that I need to get
used to using formula and other tools of excel therefore my query
might be so simple for the experienced users but I don't know how it
can be done. So excuse me for my ignorance:

I have a table that contains dates in one cell and time stamp in the
subequent cell and the same formate spanning over three months. I need
to exclude those cell having time stamp and count (month-wise) those
cells having date in them.

For example:

COLUMN A
31-Oct-07
10:49:27 PM
31-Oct-07
12:18:28 PM
30-Oct-07
12:32:27 PM

Can anyone help me?

Thanks,

Pankaj