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

[µo°Ý] §ïÅÜ?¦~¥÷Åý¤é´Á(30¤é¤Î45¤é)¥Í¦¨¬ÛÀ³ªº¤é´Á

[µo°Ý] §ïÅÜ?¦~¥÷Åý¤é´Á(30¤é¤Î45¤é)¥Í¦¨¬ÛÀ³ªº¤é´Á

¥»©«³Ì«á¥Ñ cypd ©ó 2020-9-7 23:28 ½s¿è

§ïÅÜ?¦~¥÷Åý¤é´Á(30¤é¤Î45¤é)¥Í¦¨¬ÛÀ³ªº¤é´Á

1.·í§Ú§ó§ï¦~ T2 Àx¦s®æªº®É­Ô¡A§Æ±æ(B5:V76)´N·|¥Í¦¨¬ÛÀ³ªº¤é´Á


2.¥H 9 ¤ë¬°¨Ò
   R43...¶Â¦â¼Æ¦r¬°¥¿±`¤é´Á...9/1
   R44...ºñ¦â¼Æ¦r¬°¥¿±`¤é´Á¥[ 30 ¤é©Ò²£¥Í...10/1
   R45...¬õ¦â¼Æ¦r¬°¥¿±`¤é´Á¥[ 45 ¤é©Ò²£¥Í...10/16


3.§Æ±æµ²ªG¬O·í§Ú§ó§ï ¦~ T2 Àx¦s®æªº®É­Ô
  (B5:V76)´N·|¥Í¦¨¬ÛÀ³ªº¤é´Á...(1~12¤ë¥÷ªº¤é´Á)
  ¥¿±`¤é´Á¤Î¥[ 30¤é¤Î 45¤é¤TºØ¬ÛÀ³ªº¤é´Á

1090907.rar (18.46 KB)

¦^´_ 6# hcm19522



¦¹¦¸ hcm 19522 ¤À¨É¤§¤½¦¡
¤j´TÁYµu¤£¤Ö...·P®¦Ëç   ^^
¬O§_¯à»¡©ú¦¹¦¸»P¤W¦¸¤½¦¡¤§Àu²§
TEXT(TEXT(ROW(A3)/3*7-7+MOD(COLUMN(A1)-1,7)+1-MOD(DATE($T$2,$D$3,1)-1,7),"0;;"),"[>"&DAY(EOMONTH(DATE($T$2,$D$3,1),0))&"]! ;0")

TOP

¦^´_ 4# morgan6312


    B5 §ï ¸Õ¸Õ=TEXT(TEXT(ROW(A3)/3*7-7+MOD(COLUMN(A1)-1,7)+1-MOD(DATE($T$2,1,1)-1,7),"0;;"),"[>"&DAY(EOMONTH(DATE($T$2,1,1),0))&"]! ;0")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# morgan6312

·PÁ±z~ªþ¥ó¬°¨Ì·Ó«ü¾É©Ò°µ¦¨§¹¦¨ÀɮסC
§ó·PÁ hcm19522 ªº½ç±Ð   ^^

TOP

¦^´_  hcm19522

·PÁ hcm19522  «ü¾É
(ÀH·NºÛ "EXCEL°g"  blog  ©Î http://blog.xuite.net/hcm19522/t ...
cypd µoªí©ó 2020-9-8 23:40



    ¬õ³æ¤é´Á´«ºâªí.tar (35 KB)
ªþ¥ó¬°¨Ì·Ó«ü¾É©Ò°µ¦¨§¹¦¨ÀɮסC

TOP

¦^´_ 2# hcm19522

·PÁ hcm19522  «ü¾É
(ÀH·NºÛ "EXCEL°g"  blog  ©Î http://blog.xuite.net/hcm19522/twblog)

°w¹ï¤W­zµo°Ý°ÝÃD¤w¦³¬ÛÃö¸Ñ»¡...https://blog.xuite.net/hcm19522/twblog/589336307(¸U¦~¾ä ¤@©P¤T¦æ (7342)
Àò¯q¨}¦h   ^^

TOP

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

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD