Countif and dates

[Scott]

I have a 20,000 entry spreadsheet that contains dates in this format
07/04/2010, As you can imagine there are quite a few of these entries
for each month. I want to count the number of them for a particular
month. I can't seem to use wildcards for some reason and cant find the
answer why on the net.

There formula that I would expect to work goes like this: - (ps I am
looking for all the March(03) entries in the column A)
=COUNTIF(A:A, "*/03/*")

This always returns a 0 and I can't see why?

In an ideal would I would like this to count the above AND also
countains the word EXAMPLE in the F:. I think the second part is much
easier than the first as I can easily use wildcards for searching for
things on their own.

Any help would be greatly appreciated as I am confused.com!

Scott

 

[Don Guillett]

See reply in your earlier post

 

[Zaidy036]

I have a 20,000 entry spreadsheet that contains dates in this format
07/04/2010, As you can imagine there are quite a few of these entries
for each month. I want to count the number of them for a particular
month. I can't seem to use wildcards for some reason and cant find the
answer why on the net.

There formula that I would expect to work goes like this: - (ps I am
looking for all the March(03) entries in the column A)
=COUNTIF(A:A, "*/03/*")

This always returns a 0 and I can't see why?

In an ideal would I would like this to count the above AND also
countains the word EXAMPLE in the F:. I think the second part is much
easier than the first as I can easily use wildcards for searching for
things on their own.

Any help would be greatly appreciated as I am confused.com!

Scott

maybe =COUNTIF(A:A,"month=03")

 

[ozgrid.com]

Excel sees dates as serial values and not how your dates are formatted. I
would use =Month(A1) on your dates then COUNTIF(B1:B100,3)