Data filter with months and data

[bjeiten]

Hello,

Out of a table with dates I would like to filter the number of lines that were inputted in a month.
But the input date is an exact date (example:15/11/2016)

With which formula can I always see the number of inputs per month in a table

Jan/16 XX
Feb/16 XX
... ...

Thanks in advance!

[PFDave]

Does below help?

=COUNTIF(RANGE,DATE(YEAR,MONTH,DAY))

Example based on Column A containing dates and 15/11/2016 as your date

=COUNTIF($A:$A,DATE(2016,11,15))

[bjeiten]

Not realy,

The problem is that all data are exact (dd/mm/yyyy) but I want to see the numbers per month.

Example

1 12/11/2016
2 14/11/2016
3 19/11/2016
4 02/12/2016
5 08/12/2016

Than I would like to get

Nov16 3
Dec16 2

Thanks in advance

[PFDave]

with helper column

[bjeiten]

Thank a lot!

It works perfectly

[PFDave]

Glad it helped.