COUNTIF that contains a specific date ignoring the rest

[leokiwi]

Hello guys,

I'm trying to create a formula that counts the cells that contains a specific date given by another cell for example:

	A	B
1	Dates
2	01-Jun 03:30
3	01-Jun 04:00
4	02-Jun 01:15
5	03-Jun 09:30
6
7	Calculations:
8	01-Jun	???

<tbody>
</tbody>

The idea is that B8 should give the amount of dates with the criteria on A8 using the range A2:A5

What I'm using at the moment is COUNTIF(A2:A5,A8&"**) that's obviously not working at the moment, any ideas?



Cheers,

Leo

 

[Robert Mika]

One way:

Excel 2010
	A	B
1	Dates
2	6/1/2012 3:30
3	6/1/2012 4:00
4	6/2/2012 1:15
5	6/3/2012 9:30
6
7	Calculations:
8	1-Jun	2
Sheet4

Cell Formulas
Range	Formula
B8	=SUMPRODUCT(--(MONTH(A2:A5)=MONTH(A8)),--(DAY(A2:A5)=DAY(A8)))

 

[leokiwi]

It works perfectly!!! thank you!!!

 

[Robert Mika]

You are welcome.