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

06/01/17

04/03/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

Find more posts tagged with

Healthcare

Formulas

IT & Operations

Comments

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