Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to valid the date with given condition?
Does anyone have any suggestions on how to valid the date with given condition?
For example, there is a list of date under column A, 01-May-06 06-May-06 11-May-06 13-May-06 25-May-06 .... There is a given date in cell B1 [20-May-07] and a given number 6 in cell B2. I would like to determine any date under column A within the range based on the given date [20-May-07] + / - the given number 6 days, which is between [14-May-06] and [26-May-06]. If none exists within this range, then return FALSE in cell C1, else if any date or more exist within this range, then return TRUE in cell C1. Does anyone have any suggestions on how to do it? Thanks in advance for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to valid the date with given condition?
Try this:
the given date [20-May-07] + / - the given number 6 days, which is between [14-May-06] and [26-May-06]. I think your years are messed up! =COUNTIF(A1:A5,"="&B1-B2)-COUNTIF(A1:A5,""&B1+B2)0 -- Biff Microsoft Excel MVP "Eric" wrote in message ... Does anyone have any suggestions on how to valid the date with given condition? For example, there is a list of date under column A, 01-May-06 06-May-06 11-May-06 13-May-06 25-May-06 ... There is a given date in cell B1 [20-May-07] and a given number 6 in cell B2. I would like to determine any date under column A within the range based on the given date [20-May-07] + / - the given number 6 days, which is between [14-May-06] and [26-May-06]. If none exists within this range, then return FALSE in cell C1, else if any date or more exist within this range, then return TRUE in cell C1. Does anyone have any suggestions on how to do it? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data using a date as the condition | Excel Discussion (Misc queries) | |||
count between two date with one more condition | Excel Worksheet Functions | |||
display date based on condition | New Users to Excel | |||
How to check valid Date value? | Excel Worksheet Functions | |||
Calculate a date or key a date on condition | Excel Discussion (Misc queries) |