I have an excel test so please bear with me that what I am asking for
may not be the best way to do this. Here is what I have been asked to
do.

I have daily dates from the beginning of this year to now and
corresponding data.

Using the sumproduct function I want to count the number of time that
the data is less than 1 and at the end of the month. Here is what I
have:

=SUMPRODUCT((--($K$3:$K$151=EOMONTH($K$3,1)))*--($A$3:$A$151<1))


I am stuck on the eomonth part..can anyone help?

Many thanks.