ããé¦å è¦è¯´ä½ çè¡¨æ ¼è®¾è®¡ä¸æ¯é£ä¹åçï¼æ个ç»è®¡ç»æ夹å¨ä¸ä½ç½®ï¼ç»ç¨å ¬å¼å¸¦æ¥äºéº»ç¦ãè¦ä¸å¨æåé¢ï¼è¦ä¸å¨æåé¢ãå¦å¤ä½ ææ°ä¸ªèº«ä»½è¯å·ç æ¾ä¸è¡ï¼ä¸å¯è½è¿åè¡ç人æ°ä¸ä¸ï¼è¦ä¸ä½ ä¼è¦ç»è®¡âå ±å 人âäºï¼ä¹ä¸ç¥è¿æ ·è®¾è®¡è¡¨æ ¼çç®çæ¯ä»ä¹ã
ããå ±å 人ï¼B3ä¸è¾å ¥å ¬å¼ï¼
ãã=COUNTA(A3,F3:IV3)
ããå ¬å¼ä¸çIVæ¯æ2003çExcelæ大åæ°æ¥è®¾è®¡çï¼å¯æ ¹æ®å®é å¯è½æ大åæ°æ¥ä¿®æ¹ã
ããè年人ï¼C3ä¸è¾å ¥å ¬å¼ï¼
ãã=COUNT(0/(N(DATEDIF(TEXT(MID(A3:IV3,7,8),"0000-00-00"),TODAY(),"y")>=60)))
ããæCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼
ããæªæ年人ï¼E3ä¸è¾å ¥å ¬å¼ï¼
ãã=COUNT(0/(N(DATEDIF(TEXT(MID(A3:IV3,7,8),"0000-00-00"),TODAY(),"y")<16)))
ããæCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼
ããæ年人ï¼16ï½60å²ï¼ï¼D3ä¸è¾å ¥å ¬å¼ï¼
ãã=B3-C3-E3
ããæ¤å¤ï¼ä½ çæé®ä¸è´´å¾ä¹ä¸ä¸è´ï¼æé®ä¸ï¼æ°æ®ä»¥ç¬¬1è¡ä¸ºä¾ï¼A1ãX1ãY1ãZ1ï¼èè´´å¾ä¸ä¸ä» 没æå·¥ä½è¡¨çè¡å·ååæ è´´åºï¼ä¸èµ·ç 第1ã2è¡æ¯æ é¢ã