What's wrong with this formula?

Jason Wirl

=COUNTIF(AD:AD, DAY(@cell) = 16)

I'm getting an #invalid data type error.

Column AD is a Date column and I'm just trying to count the number of days that contain the 16th.

Thank you,

Jason

Paul Newcome

You have either blanks or non-date (text) values in your date column. Try this...

=COUNTIFS(AD:AD, IFERROR(DAY(@cell), 0) = 16)