Count if Specific Text within a Date Range

Stacy Hammons

I'm trying to create a formula to count a specific text within a column only when it's during a specific date range. I can't figure out where my error is. 

=COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], >= [2020-08-01], [Date]:[Date], <=[2020-08-31])

David Joyeuse

Hi @Stacy Hammons

You can try this:

=COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], MONTH(@cell)=8)

Hope it helped!

Sean Morgan

Hello @Stacy Hammons ,

I was able to replicate the error you are facing when the Date Column was a Text/Number type, rather that a Date type, but I was also able to have the above Formula return a result when having the Date Column as a Date Type.

With this, you may want to view the Properties of your Column named Date to verify this is a Date type.

Kindest Regards

Sean

Stacy Hammons

Thank  you @Sean Morgan. I checked that. After digging a little deeper I think my problem is how it flows into the worksheet. It's not picking the date up as a date. I will reach out to get this fixed.

David Joyeuse

Hi @Stacy Hammons

You can try this:

=COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], MONTH(@cell)=8)

Hope it helped!

Stacy Hammons

@David Joyeuse Thanks, I tried that and it didn't work. It says Invalid data type. My form format is 2020-09-28. Would that make a difference?

Sean Morgan

Hello @Stacy Hammons ,

I was able to replicate the error you are facing when the Date Column was a Text/Number type, rather that a Date type, but I was also able to have the above Formula return a result when having the Date Column as a Date Type.

With this, you may want to view the Properties of your Column named Date to verify this is a Date type.

Kindest Regards

Sean

Stacy Hammons

Thank  you @Sean Morgan. I checked that. After digging a little deeper I think my problem is how it flows into the worksheet. It's not picking the date up as a date. I will reach out to get this fixed.