Array Formula Error

[CecesWorking]

I have a data set similar to below

Date Field 1 Field 2 Field 3
1/1/09 x x o
1/5/09 o x x
1/14/09 o o x

I also have an array formula in a separate cell that looks for the row with
the closest match to today's date and is supposed to return the row number
that is the closest match. The formula is:
=MATCH(MIN(ABS($A:$A-TODAY())),ABS($A:$A-TODAY()),0)

But now I receive a new error: #NUM!

All of the dates only live in Column A. I am not sure what I'm doing wrong.

Any help would greatly be appreciated.

Thanks for your time and effort.

 

[JBeaucaire]

Try removing the reference to the entire column, just use a range bi
enough for your needs

=MATCH(MIN(ABS($A1:$A20000-TODAY())),ABS($A1:$A20000-TODAY()),0