å ä¸ºä½ çCåä¸æ¯æ¥ææ°æ®ï¼æ以æç½ä¸çâæ¹æ³âï¼å æ¬å·²æä¾ç»ä½ çæ¹æ³ï¼é½æ¯æ æ³å¾å°æ£ç¡®ç»æçãæ以建议è¾å ¥æ°æ®è¦è§èï¼è¾å ¥æ¥ææ°æ®æ¶ï¼ä»¥âyyyy/m/d"æâyyyy-m-dâçæ ¼å¼è¾å ¥ï¼è¿æ ·ä¼ç»èªå·±çæ°æ®å¤ç带æ¥æ¹ä¾¿ã
ç°å¨è¿æ ·çè®°å½ï¼è¦å æCåæ°æ®è½¬æ¢ä¸ºæ¥ææ°æ®ï¼å设æ°æ®å°13è¡ï¼å ¬å¼ï¼
æ大æ¥æï¼
=MAX(IF((A$2:A$13="BU01")+(A$2:A$13="BU03"),DATE(--RIGHT(C$2:C$13,4),--LEFT(RIGHT(C$2:C$13,7),2),--LEFT(C$2:C$13,LEN(C$2:C$13)-8))))
æå°æ¥æï¼
=MIN(IF((A$2:A$13="BU01")+(A$2:A$13="BU03"),DATE(--RIGHT(C$2:C$13,4),--LEFT(RIGHT(C$2:C$13,7),2),--LEFT(C$2:C$13,LEN(C$2:C$13)-8))))
å为æ°ç»å ¬å¼ï¼è¦åæ¶æCtrl+Shift+Enterä¸é®å®æå ¬å¼è¾å ¥ã