Counting month and year from a date column

[RamboDanbo]

Hi,

Can someone suggest a formula for counting the number of occurences of a month & year in a date column?

The spreadsheet is looking at items raised in any given month e.g. all items raised in Dec-08.

Many thanks,

[daddylonglegs]

Try

=SUMPRODUCT(--(TEXT(A1:A100,"mmm-yy")="Dec-08"))

[RamboDanbo]

perfect! many thanks for that!

[VBA Noob]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

VBA Noob