Does anyone have any suggestions on how to filter the date in following
example?
There is a list of date in cell A1:A10, which is always later than / equal
to today,
if today is 22 May, then the list could be 25 May, 28 May, 4 Jun, ...
and a special date is located in cell B1, which could be any date, such as
18 May or 22 May or 25 May

I would like to determine the minimum date from the list in cell A1:A10
without filtering,
25 May, 28 May, 4 Jun, ...
and including the date in cell B1 too. With the filter condition,
if the date in cell B1 is earlier than today, then ignore this date, [18 May]
if the date in cell B1 is today, then include this date, [22 May]
if the date in cell B1 is later than today, then include this date, [25 May]

Does anyone have any suggestions
Thank for any suggestions
Eric

Try this:
=IF(B1<TODAY(),MIN(A1:A10),MIN(A1:A10,B1))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Eric" wrote in message
...
Does anyone have any suggestions on how to filter the date in following
example?
There is a list of date in cell A1:A10, which is always later than / equal
to today,
if today is 22 May, then the list could be 25 May, 28 May, 4 Jun, ...
and a special date is located in cell B1, which could be any date, such as
18 May or 22 May or 25 May

I would like to determine the minimum date from the list in cell A1:A10
without filtering,
25 May, 28 May, 4 Jun, ...
and including the date in cell B1 too. With the filter condition,
if the date in cell B1 is earlier than today, then ignore this date, [18
May]
if the date in cell B1 is today, then include this date, [22 May]
if the date in cell B1 is later than today, then include this date, [25
May]

Does anyone have any suggestions
Thank for any suggestions
Eric

Thank you very much for your suggestions
Eric

"Bernard Liengme" wrote:

Try this:
=IF(B1<TODAY(),MIN(A1:A10),MIN(A1:A10,B1))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Eric" wrote in message
...
Does anyone have any suggestions on how to filter the date in following
example?
There is a list of date in cell A1:A10, which is always later than / equal
to today,
if today is 22 May, then the list could be 25 May, 28 May, 4 Jun, ...
and a special date is located in cell B1, which could be any date, such as
18 May or 22 May or 25 May

I would like to determine the minimum date from the list in cell A1:A10
without filtering,
25 May, 28 May, 4 Jun, ...
and including the date in cell B1 too. With the filter condition,
if the date in cell B1 is earlier than today, then ignore this date, [18
May]
if the date in cell B1 is today, then include this date, [22 May]
if the date in cell B1 is later than today, then include this date, [25
May]

Does anyone have any suggestions
Thank for any suggestions
Eric