Why this formula's returns #INVALID DATA TYPE

Louis Raoul

Hello,

I wonder if so can help me understand why this formula does not work.

=COUNTIF([Request Date]:[Request Date], MONTH(@cell) = 10)

Where the Request Date is indeed a Date column.

It is probably pretty obvious but cannot find it.

Raoul.

Andrée Starå

Hi @Louis Raoul t'Serstevens

Try something like this.

=COUNTIF([Request Date]:[Request Date, IFERROR(MONTH(@cell), 0) = 10)

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mark Cronk

When the MONTH() function contains a blank cell within the range of dates it is reviewing, it will produce the error. This is expected behavior. To resolve this, you’ll want to utilize an IFERROR() function as proposed by Andree.

Andrée Starå

Hi @Louis Raoul t'Serstevens

Try something like this.

=COUNTIF([Request Date]:[Request Date, IFERROR(MONTH(@cell), 0) = 10)

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mark Cronk

When the MONTH() function contains a blank cell within the range of dates it is reviewing, it will produce the error. This is expected behavior. To resolve this, you’ll want to utilize an IFERROR() function as proposed by Andree.

Louis Raoul

Thank you very much Andree

I tried this as well, but it returns 0 indicating indeed that @cell returns an error.

I'm puzzled I must say.

Thanks a lot and have a great day.

Raoul

Andrée Starå

@Louis Raoul t'Serstevens

Happy to help!

Strange!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Louis Raoul

Thank you very much Andree & Mark

It is working. I was not aware of the error in case of blank cell.

Again thanks a lot :)

Andrée Starå

@Louis Raoul t'Serstevens

Excellent!

You're more than welcome!