ªð¦^¦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)

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

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

¦^´_  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

¦^´_ 4# morgan6312

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

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

¦^´_ 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

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD