每家门店现有合同还有多少个月 (9053)

F2(日期需依次序)=DATEDIF(LOOKUP(1,0/(A$2:A12=E2)/(B$2:B12<TODAY()),B$2:B12),LOOKUP(1,0/(A$2:A12=E2),C$2:C12)+1,"M")&"月"

另解{=DATEDIF(MAX(IF((A$2:A12=E2)*(B$2:B12<TODAY()),B$2:B12)),MAX(IF((A$2:A12=E2),C$2:C12))+1,"M")&"月"