CountIF / IsDate combination

angel.blanquet93966

Hello

I am trying to link formulas to count from a list or column all the cells that contain date and discard that which are text. But I can not get the combination of the formulas to work well.

Thank you in advance.

Paul Newcome

Try something along the lines of

 

=COUNTIFS([Date Column]:[Date Column], ISDATE(@cell))

 

If that doesn't work, could you provide your current formulas and a little more detail?

Peggy Parchert

@Paul Newcome

I realize this thread is a couple years old but I can't seem to get my COUNTIFS/ISDATE formula to work.

Current formula:

=IFERROR(COUNTIFS(OR(Date1:Date1, ISDATE([email protected]), Date2:Date2, ISDATE([email protected]), Date3:Date3, ISDATE([email protected]), Date4:Date4, ISDATE([email protected]), Date5:Date5, ISDATE([email protected]), Date6:Date6, ISDATE([email protected]), Date7:Date7, ISDATE([email protected]))), "")

I'm getting the #incorrect argument message. What do I have wrong?

Thanks, Peggy

Paul Newcome

@Peggy Parchert Are you able to describe exactly what you are wanting to accomplish and what your various column names are?

Peggy Parchert

@Paul Newcome

I want to know the count of how many of my date columns (Date1-Date7) have dates in them.

In the above example, it should show 6 in the Count column but I can't make it work.

Count is a text/number column

Date columns (Date1-Date7) is restricted to Date columns.

Thanks for the assistance.

Peggy

Paul Newcome

Try this:

=COUNTIFS([Date1]:[Date7], @cell <> "")

Peggy Parchert

@Paul Newcome

That gives me the count of the whole range but not by line. I probably should have said that above.

Paul Newcome

=COUNTIFS([Date1]@row:[Date7]@row, @cell <> "")

Peggy Parchert

@Paul Newcome

That worked! Thank you so much!

Peggy

Paul Newcome

Happy to help. 👍️