That time of the month

BrianDP1977

Board Regular
Joined
Nov 5, 2005
Messages
146
Within a range of dates (named "Course_Start"), I would like to determine how many of those have the same month start date as a date defined in cell D3. I thought I could simply use a COUNTIF statement to do this but am getting errors.

=COUNTIF(Course_Start, MONTH(Course_Start)=MONTH(D3))
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
I think you need a helper column which calculates the month of each date within the range Course_Start.
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
=SUM(IF(MONTH(A1:A10)=MONTH(D3),1))

...entered with control + shift + enter. not just enter
 

BrianDP1977

Board Regular
Joined
Nov 5, 2005
Messages
146
PaddyD, looks like it works. Thanks. I always forget about that whole Ctrl + Shift + Enter thing.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,330
Members
412,716
Latest member
thviid
Top