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

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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD