![]() |
#2
|
||||
|
||||
![]() Quote:
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","")
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|