éæ©èº«ä»½è¯å·ç æ°æ®åºåï¼å¦å¾ä¸çC2:C23ï¼ï¼å¼å§é项å¡ââæ¡ä»¶æ ¼å¼ââæ°å»ºè§åââ使ç¨å ¬å¼ç¡®å®è¦è®¾ç½®æ ¼å¼åå æ ¼ï¼å¨ä¸ºç¬¦åæ¤å ¬å¼çå¼è®¾ç½®æ ¼å¼ï¼Oï¼ä¸é¢çæ¡ä¸è¾å ¥ï¼
=MID($C2,11,2)="01"
æ ¼å¼ï¼å¡«å ï¼éæ©å好çé¢è²ï¼ç¡®å®ï¼åç¡®å®ã
å¦æè¦çªåºæ¾ç¤ºå½åæ份çæ¥çï¼å°å ¬å¼ä¿®æ¹ä¸ºï¼
=--MID($C2,11,2)=MONTH(TODAY())
追é®ææä½ è¿ä¸ªåäºï¼è¯äºä¸éï¼å ¬å¼ä¹ä¸æ¨¡ä¸æ ·ï¼ä¸ºå¥ç¹äºç¡®å®ä»¥å没æä»»ä½ååºã
追ç追é®æ好æªå¾ï¼å¦æåæ¬äººåçé®é¢ä¸æ ·æå¾æªå¾ä¸æ¥ï¼å°±æå¯è½å¸®ä½ åæé®é¢ãæªå¾æ¶è¦æå·¥ä½è¡¨è¿åä¸é¢çåæ ï¼ABCDçï¼å左边çè¡å·ï¼12345çï¼æªå¾ä¸æ¥ï¼åæä½ è®¾ç½®çæ¡ä»¶æ ¼å¼ä¹æªå¾ãå¦åå¦ä½åçä½ ï¼çä¹ä¸æ æ³çåã