Excelæå·¥å¶ä½ä¸å¹´å
1.é¦å
ï¼æ°å»ºä¸ä¸ªExcelæ件ãå¨å¾ç¤ºçº¢æ¡ä½ç½®çåå
æ ¼åºåè¾å
¥ç¸åºå
¬å¼ãå
¶ä¸B1=TODAY()F1=IF(WEEKDAY(B1,2)=7,"æ¥",WEEKDAY(B1,2))H1=NOW()å¨ç¬¬2è¡ï¼åå
æ ¼A2å°H2åå«è¾å
¥å
¬å¼A2=IF(F13=2,IF(OR(D13/400=INT(D13/400),AND(D13/4=INT(D13/4),D13/100<>INT(D13/100))),29,28),IF(OR(F13=4,F13=6,F13=9,F13=11),30,31))
B2=IF(WEEKDAY(DATE($D$13,$F$13,1),2)=B3,1,0)
C2=IF(WEEKDAY(DATE($D$13,$F$13,1),2)=C3,1,0)
D2=IF(WEEKDAY(DATE($D$13,$F$13,1),2)=D3,1,0)
E2=IF(WEEKDAY(DATE($D$13,$F$13,1),2)=E3,1,0)
F2=IF(WEEKDAY(DATE($D$13,$F$13,1),2)=F3,1,0)
G2=IF(WEEKDAY(DATE($D$13,$F$13,1),2)=G3,1,0)
H2=IF(WEEKDAY(DATE($D$13,$F$13,1),2)=H3,1,0)
2.å¨åå
æ ¼B6å°H6åå«è¾å
¥å
¬å¼
B6=IF(B2=1,1,0)
C6=IF(B6>0,B6+1,IF(C2=1,1,0))
D6=IF(C6>0,C6+1,IF(D2=1,1,0))
E6=IF(D6>0,D6+1,IF(E2=1,1,0))
F6=IF(E6>0,E6+1,IF(F2=1,1,0))
G6=IF(F6>0,F6+1,IF(G2=1,1,0))
H6=IF(G6>0,G6+1,IF(H2=1,1,0))
3.å¨åå
æ ¼B10å°H10ï¼åå«è¾å
¥å
¬å¼
B10=IF(H9>=A2,0,H9+1)
C10=IF(B10>=$A$2,0,IF(B10>0,B10+1,IF(C6=1,1,0)))
D10=IF(C10>=$A$2,0,IF(C10>0,C10+1,IF(D6=1,1,0)))
E10=IF(D10>=$A$2,0,IF(D10>0,D10+1,IF(E6=1,1,0)))
F10=IF(E10>=$A$2,0,IF(E10>0,E10+1,IF(F6=1,1,0)))
G10=IF(F10>=$A$2,0,IF(F10>0,F10+1,IF(G6=1,1,0)))
H10=IF(G10>=$A$2,0,IF(G10>0,G10+1,IF(H6=1,1,0)))
4.æåå¨åå
æ ¼B7åH9è¾å
¥å¾ç¤ºå
¬å¼ãå¨å¾ç¤ºç»¿è²æ¹æ¡ä½ç½®çåå
æ ¼åºåè¾å
¥æååæ°åãå
¶ä¸ï¼Iåï¼ä¾æ¬¡è¾å
¥å¹´ä»½æ°å1900å°2050Jåï¼ä¾æ¬¡è¾å
¥æ份æ°åï¼1å°12
5.ä¸é¢ï¼æ们éè¦åç¾åã
é¦å
ï¼æå¼è§å¾é项ï¼åæ¶å¾éç½æ ¼çº¿ãå°ç½æ ¼çº¿éèã设置æ¥åè¾¹æ¡ï¼ä»¥å设置åä½å±
ä¸å¯¹é½ãå°æ é¢åä½æ¾ç¤ºå¾æ´å éç®ä¸äºã设置ç¸åçåä½é¢è²åèæ¯è²å°ä¸éè¦å±ç¤ºçå
容éèæåï¼ä¸ºäºè½å¤å®ç°æ¥è¯¢æ¥æçåè½ãéè¦å¨åå
æ ¼D13ï¼è®¾ç½®æ°æ®æææ§ãå¨åå
æ ¼F13æ份ï¼åæ ·è®¾ç½®ä¸ä¸æ°æ®æææ§ãæåæ个é®é¢ï¼åå
æ ¼H1æ¶é´ä¸è½å®æ¶æ´æ°ï¼æ们å¯ä»¥æä¸F9ï¼è®©å®éæ¶æ´æ°ã
温馨提示:答案为网友推荐,仅供参考