Quote:
contains a date greater than two years ago
|
I understand this as a date between today and today minus two years (if not replace the > with a <)
I suppose subtracting 24 months from the present date will doto return the dat from
Thus, in D1
Code:
= if(and(isnumber(search("active",a1)),c1=0,b1>edate(today(),-24)),"Move","")