Formulas with dates

[bines53]

Hello friends ,

I have a few questions about formulas with dates,
I have no experience with such formulas.
Column A dates, column B data,

1,How many times have listed the number 2 in 2015 ?
2,How many times listed number 2, in the eighth month, in 2015 ?
3,How many times listed number 2, on the tenth day, the eighth month, in 2015 ?
4,How many times listed number 2, on the tenth day, the eighth month, in all years ?
5,What is the number of rows of data, there is the eighth month, in 2015?
6,What is the first and last row, in eighth month, in 2015?

Thank you !

 

[Nebu]

Hi:

Hope this is what you are looking for.

Thanks

 

[bines53]

Hi Nebu ,

All formulas, short and right !

Perfect !

Maybe I will have other questions later .

Thank you !