Using COUNTIF and MONTH() to Find a Specific Date

Kevin Mellander

Hello:

 

For a given set of rows with due dates:

 

04/03/17

04/28/17

04/03/17

04/03/17

06/01/17

04/03/17

05/17/17

05/17/17

04/28/17

 

I need a formula that will count up all those due in April. I am working with the following formula, but it is not quite right yet:

 

=COUNTIF(DueDate:DueDate, @cell MONTH(DueDate:DueDate) = 4)

 

Can someone lend a hand? Thanks!

 

Kevin

Larry Witham

Kevin,

This worked for me

=COUNTIF(Date2:Date10, MONTH(@cell) = 4)

You just cannot put the formula into a date type cell, so it cannot be in the Date column. 

 

Hope that helps.

 

Larry

Kevin Mellander

Thanks Larry! It looks like I needed to specify the cell range and evaluate using @cell within (rather than outside of) the MONTH() function. Thanks again!

 

Kevin