Select rows in a date range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ryguy7272 - 04 Mar 2008 17:43 GMT

This code from Bob Phillips works brilliantly for two input dates that match
the dates in the range!!
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.excel.programming&tid=e7248004-9aa9-4c38-8281-6e73155d753e&cat=&lang=en&cr=US&s
loc=en-us&p=1

I am wondering how to make a change to allow Excel to find the next higher
date in the range if there is not an exact match between the two input dates
and the dates in the range.

Thanks so much,
Ryan--

Signature

RyGuy

Reply to this Message

ryguy7272 - 06 Mar 2008 14:43 GMT

Ah! I got it! Just changed those zeros to ones. From Excel's help:
If match_type is 1, MATCH finds the largest value that is less than or equal
to lookup_value.

Thanks to anyone who looked at this and thanks to you Bob for coming up with
the code and posting it on this DG!!

Ryan--

Signature

RyGuy

> This code from Bob Phillips works brilliantly for two input dates that match
> the dates in the range!!
[quoted text clipped - 6 lines]
> Thanks so much,
> Ryan--

Reply to this Message