Hi Bob,

I want to learn more about the use of -- in Excel. Any good suggestions?
Thanks.

"Bob Phillips" wrote:

=COUNTIF(A:A,"="&--"2008-01-02")-COUNTIF(A:A,"="&--"2008-01-03")

=SUMPRODUCT(--(A1:A8=--"2008-02-01"),--(A1:A8<--"2008-03-01"),--(ISNUMBER(SEARCH("Peter",B1:B8))))

--
__________________________________
HTH

Bob

"Freshman" wrote in message
...
Dear experts,

I've a worksheet with data in Column A to Column F. Column A is for dates
and column B is for names. I list some examples below:

12 Jan 08 Peter Ho Leung
22 Feb 08 Mary Kwan Yim
28 Mar 08 Peter Mung Ching
30 Apr 08 June Liew
3 Feb 08 June Tam Ho
13 Apr 08 Peter Lan Chi
26 May 08 Monica Cheung
27 Feb 08 Peter Cheng

Firstly, I want to count how many records in Feb 08. Secondly, I want to
count how many records with the name "Peter". I try to use the formulas
below
but they don't work.

=COUNTIF(A1:A8,"*Feb*") and
=COUNTIF(B1:B8,"Peter*")

Please advise. Thanks in advance.