|
How to filter the date?
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 |
How to filter the date?
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 |
How to filter the date?
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 |
| All times are GMT +1. The time now is 05:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com