Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I often have a need to compare a date with two other dates and see
whether dateA is between dateB and dateC. I have tried to use the "IF" function but it doesn't seem to take arguments as complicated as "IF ((A=B) and (A<=C))" which is basically what I am asking. I've been having to use two different T/F columns and just take the ones that are TRUE in both, but that is very cumbersome. Is there a more sophisticated way to ask if A is between B and C? Thanks... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
number checking | Excel Discussion (Misc queries) | |||
number checking | Excel Discussion (Misc queries) | |||
Checking if a number appears within a cell | Excel Discussion (Misc queries) | |||
Checking a number of sheets | Excel Worksheet Functions | |||
Checking cell for Number | New Users to Excel |