ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¶g²Î­p

[µo°Ý] ¶g²Î­p

¤j¤j­Ì¦n¡G
1..        ÅýAÄæ¦Û°Ê¥X²{¶g§OW1¡BW2¡K,¨ÌBÄæ¤é´Á="¶g¤é",«hAÄæ¥X²{W1,¹JBÄæ²Ä¤G­Ó¶g¤é,«hAÄæ¥X²{W2¡K¨Ì¦¹Ãþ±À
2..        E¡BH¡BKÄ檺"¶g²Î­p",¨Ì¥_¡B¤¤¡B«n°Ï&¨Ì¶g§O¦Û°Ê¥[Á`"±b¸¹1~2",¨C¶g²Î­p¼Æ¶q¤£²Ö­p
3..        ¶g²Î­p¨ÌAÄæ¥X²{W1¡BW2¡K,¤]´N¬O¦³¶g§O¥X²{¤~­n²Î­p,¤£µM´NªÅ¥Õ
4..        ½Ð°Ý¸Ó¦p¦ó¥Î¨ç¼Æ¼g¥X¥H¤W­n¨D?
¶g²Î­p.rar (31.63 KB)

8/1 ¬O©P¤é, ³o¤@¤Ñºâ²Ä¤@©P???
8/31 ¬O©P¤G,¤£¬O©P¤é, «çºâ???

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# ­ã´£³¡ªL

8/31 ¬O©P¤G,¤£¬O©P¤é, «çºâ??
¨C¤ë³Ì«á¤@¤Ñ,¥iµø¬°³Ì«á¤@¶gªº¶g¤é,³o¼Ë´N¥i¥H²Î­p§¹¾ãªº¤@­Ó¤ë

TOP

A5:¤U©Ô
=IF(OR(MOD(N(B5),7)=1,B5=DATE(B$1,C$1+1,0)),"W"&COUNTIF(A$4:A4,"W*")+1,"")

E5:¤U©Ô
=IF($A5="","",SUM(C$4:D5)-SUM(E$4:E4))
¶K¦ÜH5/K5

L5:
=IF($A5="","",SUMIF(C$4:K$4,K$4,C5:K5))

TOP

¦^´_ 5# ­ã´£³¡ªL

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD