好åä½ å¯¹è¿ä¸ªå·¥ä½è¡¨æäºä¸¤ä¸ªé®é¢ï¼ä¸¤ä¸ªé®é¢ä¸å¹¶ç»ä½ 解å³å§ï¼å ä¸ºä½ çæªå¾æ¯è¾å¤§ï¼ä¹çä¸åºè¡å·ï¼èªå·±æ ¹æ®åçé®é¢çæªå¾åå
¬å¼å»ä¿®æ¹ä¸å§ãè²ä¼¼ä½ çæ é¢æ¯å并åå
æ ¼ï¼ä½æ°æ®åºè¯¥æ¯å¨F1ä¸å§ï¼ä¸é¢çå
¬å¼å°±æ¯ä»¥æ é¢å¨F1ä¸è®¾ç½®çï¼å
è¾å
¥æ¥æå
¬å¼ï¼
=IF(DATE(LEFT($F$1,4),MID($F$1,6,2),COLUMN(A:A))>EOMONTH(DATE(LEFT($F$1,4),MID($F$1,6,2),1),0),"",TEXT(DATE(LEFT($F$1,4),MID($F$1,6,2),COLUMN(A:A)),"d"))
å³æå°åºç°1个以ä¸ç©ºç½åå
æ ¼ï¼F1ä¸æå°æ¶ï¼æ大æ¶ç©ºç½åå
æ ¼ä¼æ¾ç¤º31ï¼
åå¨ä¸ä¸è¡è¾å
¥ææçå
¬å¼ï¼
=IF(F4="","",TEXT(DATE(LEFT($F$1,4),MID($F$1,6,2),COLUMN(A:A)),"aaa"))
å³æå°ä¸ä¸ä¸è¡å¹³é½
追çä¸ç¥ä¸ä¼ çæªå¾æä¹ä¸è§äºï¼éæ°ä¸ä¼ ä¸ï¼
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7af40ad162d9f2d3f465693ea2ec8a136227ccef?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)