| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
True/False Comparison of Dates
Three colums:
~ Columns A and B have dates in them ~ Column C = True if B is between 1-30 days less than A Thanks for your help. Randy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
True/False Comparison of Dates
=AND((A1-B10),(A1-B1<31))
-- Gary''s Student - gsnu200787 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
True/False Comparison of Dates
=IF(AND((A1-B10),(A1-B1<31)),€¯True€¯,€¯False€¯)
"Randy" wrote: Three colums: ~ Columns A and B have dates in them ~ Column C = True if B is between 1-30 days less than A Thanks for your help. Randy |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
True/False Comparison of Dates
That's close but I think I need to clarify:
~ Column B will always be a date "after" column A ~ I need Column C to reflect "True" if Column B is fewer than 30 days "after" Column A and "False" if 30 days or more than Column A. A B C 2/16/98 3/9/98 True Thanks! "Randy" wrote: Three colums: ~ Columns A and B have dates in them ~ Column C = True if B is between 1-30 days less than A Thanks for your help. Randy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| True/False Comparison | Excel Discussion (Misc queries) | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| TRUE/FALSE | Excel Worksheet Functions | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
Linear Mode
