Hi, I have a file with 4 columns with dates. Using if function, I am trying to check whether the last date is correct (within ranges of other dates). The date, which I am checking is in column D, the logic is that the date can't be less than date in column B and it can't be higher than column C. If column C is empty than not higher than column A. I was trying to use :=IF(AND(D2>=B2,D2<C2,D2<A2),"Yes","No"),but it doesn't seems to work. I'd appreciate some help with this formula.
Bookmarks