Hi,

=SUMPRODUCT(--(YEAR(A2:A65536)=YEAR(TODAY())))


Mike

"Richard" wrote:

Mike

Thanks for the reply. I found the issue was that I had entered
=sumproduct(--(year(a:a)=year(today()))) with there being a lable (column
header) in cell a2. I kept getting a return of #NUM!

Is there a way around the label issue.

Richard

"Mike H" wrote:

Try

=SUMPRODUCT(--(YEAR($A$1:$A$100)=YEAR(TODAY())))

Mike

"Richard" wrote:

I must be going senile, as I can usually crack these things, but I am having
massive problems counting dates.

In column A I have the date entered as follows:
=TEXT(WORKDAY(A636,1),"dd-mmm-yy")

I need to count every date where the year is equal to the current year.

Please put me out of my misery and I apologise for such a dumb ass question.

Richard