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

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

=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

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

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