How can I match a calculated date to closest date from a list?

I'm trying to match a calculated date to the next meeting date from a list of
meeting dates.

Any help greatly received

Thanks

David

=MATCH(myDate,Range(A1:A100,0)

will return the index in A1:A100 of the found value.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"David P" David wrote in message
...
I'm trying to match a calculated date to the next meeting date from a list
of
meeting dates.

Any help greatly received

Thanks

David

Hi David

As Bob says, MATCH is probably your best bet. Assuming your meeting
dates are sorted in ascending order, then the following construct is
most likely to suit:

=MATCH(A1,$B$1:$B$100,-1)

where A1 houses your calculated date, B1:B100 holds your meeting dates,
and the -1 specifies a value equal to or the next higher value than
your calculated date (ie so the 'next' meeting date).

Hope this helps!

Richard


David P wrote:

I'm trying to match a calculated date to the next meeting date from a list of
meeting dates.

Any help greatly received

Thanks

David