Counting Dates - Not Text

D

Danny

Hi,

I'm trying to count the number of "date" occurrences on a particular month.
However in the same column, aside from dates, there are TEXT entries and
blank cells.

When I use the formula below it gives me a #VALUE!

Please edit the formula below so I can count the number of date occurences.

=SUMPRODUCT(--(MONTH('Date'!J2:J1116)=1))

Thank you.
 
B

Biff

Try it like this:

=SUMPRODUCT(--(ISNUMBER(DATE!J2:J1116)),--(TEXT(DATE!J2:J1116,"m")="1"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top