ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] EXCEL ¨Ì²£«~§O§PÂ_¬O§_¥i¥Î

=IF(COUNTA(A2:C2)<3,"",IF(TODAY()-DATE(A2+1911,B2+1,0)>2^AND(C2<>{"C6","C66"})*365,"¤£",)&"¥i¥Î")

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD