That time of the month

[BrianDP1977]

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))

 

[njimack]

I think you need a helper column which calculates the month of each date within the range Course_Start.

 

[PaddyD]

=SUM(IF(MONTH(A1:A10)=MONTH(D3),1))

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

 

[BrianDP1977]

PaddyD, looks like it works. Thanks. I always forget about that whole Ctrl + Shift + Enter thing.