Error #value! in a date array formula

[Jiggers]

In range A1:A1000 I have dates spanning may years with some blank cells in the range.
I use this array formula {=MAX(IF(YEAR(A1:A1000)=C2,A1:A1000))}, in C2 I have 2018. This formula finds the last date entered in 2018. If there is any text in the range A1:A1000 I get the error #VALUE!. Is there a way to stop getting this error if there is text in the range? I have added additional conditions like ISNUMBER, but I still get the error.

Any help would greatly be appreciated.

[Pete_UK]

Try it like this:

=MAX(IF(ISNUMBER(A1:A1000),IF(YEAR(A1:A1000)=C2,A1:A1000)))

Commit using Ctrl-Shift-Enter.

Hope this helps.

Pete

[Root_]

... Is there a way to stop getting this error if there is text in the range?..

Yes, there is -- adding just four symbols to your array formula

=MAX(IF(YEAR(N(+A1:A1000))=C2,A1:A1000))

[Jiggers]

Thank you both for your quick reply's . Both formulas worked perfectly.
I am very interested how this formula works MAX(IF(YEAR(N(+A1:A1000))=C2,A1:A1000)).