I need a formula that will count the dates in column A and show how many of each month.

Example of the data in Column A

• 12/1/21
• 12/10/21
• 12/29/21
• 12/30/21
• 1/11/22
• 1/12/22
• 5/2/22

The returned data would be (or similar - I just need to know the total per month over the years)

• 12/21 - 4
• 1/22 - 2
• 5/22 - 2
• and so on.

Here is what I go so far.

=ArrayFormula(month('tab name'!A2:A10))

but this list the months and not counts them.

CodePudding user response：

use:

=INDEX(QUERY(TEXT(A1:A, "mmm e"), 
 "select Col1,count(Col1) 
  where Col1 <> 'Dec 1899' 
  group by Col1 
  label count(Col1)''"))