ExcelBanter - Count cells in date range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count cells in date range (https://www.excelbanter.com/excel-worksheet-functions/137544-count-cells-date-range.html)

Clay

Count cells in date range

Lets assume I have all my dates in one column (T). How can I count the
number of occurances I have per month. I want a count of all dates in Jan,
Feb, etc. for that year.

My data will be setup like this:
A B C
D
1/01/2006 2/01/2006..... 1/01/2007 2/01/2007....
1 Count of Date

Teethless mama

Count cells in date range

=SUMPRODUCT(--(TEXT(A1:A100,"mmmyy")="Jan07"))

"Clay" wrote:

Lets assume I have all my dates in one column (T). How can I count the
number of occurances I have per month. I want a count of all dates in Jan,
Feb, etc. for that year.

My data will be setup like this:
A B C
D
1/01/2006 2/01/2006..... 1/01/2007 2/01/2007....
1 Count of Date

Clay

Count cells in date range

"Teethless mama" wrote:

=SUMPRODUCT(--(TEXT(A1:A100,"mmmyy")="Jan07"))

"Clay" wrote:

Lets assume I have all my dates in one column (T). How can I count the
number of occurances I have per month. I want a count of all dates in Jan,
Feb, etc. for that year.

My data will be setup like this:
A B C
D
1/01/2006 2/01/2006..... 1/01/2007 2/01/2007....
1 Count of Date

All times are GMT +1. The time now is 05:23 AM.