Verify if there's a date in a range.

[eduzs]

I need a formula that find the position (if there's one) of a date in a range (rows range).

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]100
[/TD]
[/TR]
[TR]
[TD]ABCD
[/TD]
[/TR]
[TR]
[TD]3/3/2017
[/TD]
[/TR]
[TR]
[TD]12,1
[/TD]
[/TR]
[TR]
[TD]#$%
[/TD]
[/TR]
</tbody>[/TABLE]

= " MATCH(ISDATE(A1:A5)=TRUE)"=3

Thanks.

 

[Scott Huish]

Question repeated here:

https://www.mrexcel.com/forum/excel-questions/1022655-find-position-date.html#post4907774