推推
IP5720
=IF(OR(COUNTIF(亂碼編輯頁!W$5:W$300,C2))*ISERR(0/((MIN(DATE(201&LEFT(D2),MID(D2,2,2)+{6,7},DAY(1&LEFT(D2)&"/"&MID(D2,2,2)&"/"&MID(D2,7,2))*{1,0})))=--E2)),"反紅","")
460P 432, 6
=IF(NOT(OR(COUNTIF(亂碼編輯頁!AC$5:AC$300,C2))),"",IF(E2=DATE(LEFT(D2,1)+2010,MID(D2,2,2)+4,MID(D2,4,2)),"","反紅"))
T5011, 552,
=IF(NOT(OR(COUNTIF(亂碼編輯頁!AD$5:AD$300,C2))),"",IF(E2=DATE(LEFT(D2,1)+2010,MID(D2,2,2)+6,MID(D2,4,2)),"","反紅"))
A30
=IF(ISERR(0/((LEFT(D98)+2021&"/"&FIND(MID(D98,6,1),"ABCDEFGHJKLM")&"/"&MID(D98,7,2))-E98-(E98-"2017/2/25"<0)=0))*COUNTIF(亂碼編輯頁!BV$5:BV$300,C98)*((MONTH(E98)=2)*(DAY(E98)>27)=0),"反紅","")
7030
=IF(ISERR(0/((LEFT(D129)+2011&"/"&FIND(MID(D129,6,1),"ABCDEFGHJKLM")&"/"&MID(D129,7,2))-E129-(E129-"2017/3/31"<0)=0))*COUNTIF(亂碼編輯頁!AG$5:AG$300,C129)*((YEAR(E129)=2122)+(MONTH(E129)=2)*(DAY(E129)>27)=0),"反紅","")
OK73
=IF(OR(AND(COUNTIF(亂碼編輯頁!BL$5:BL$300,C132)=0),C132="",YEAR(E132)=2122,E132=DATE(2118,5,20)),"",IF(ISNUMBER(SUM(--MID(D132,{1,2,3,4,5,6,7,8},1)))=FALSE,"反紅",IF(DATE(2010+LEFT(D132),MID(D132,2,2),MID(D132,FIND(" ",D132)-2,2))=DATE(YEAR(E132)-1,MONTH(E132),DAY(E132)),"","反紅")))
------------------------------沒問題的----------------------
I-8124ER
=IF(OR(C2="",--TEXT(E2,"mdd")={228,229},AND(COUNTIF(亂碼編輯頁!BI$5:BI$300,C2)=0)),"",IF(COUNT(0/(LEFT(D2,1)&FIND(MID(D2,2,1),"123456789XYZ")&MID(D2,3,2)=MID(TEXT(EDATE(E2,-6)+1,"ymdd"),2,9))),"","反紅"))
HD4104
=IF(OR(C2="",AND(COUNTIF(亂碼編輯頁!BJ$5:BJ$300,C2)=0)),"",IF(COUNT(0/(CODE(D2)=72)/(MID(D2,2,2)&MID(D2,4,2)=TEXT(EDATE(E2,-24),"ymm"))),"","反紅"))
|