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

¤ë¾ä¤½¦¡¦³»~

¤ë¾ä¤½¦¡¦³»~

¤ë¾ä¤½¦¡¦³»~

¤S¦³¤ë¾äªº°ÝÃD­n¨Ó½Ð±Ð¦U¯«³q¼s¤jªº«e½ú¤F~

³o­ÓÀɮ׬O§Ú±q¨ä¥Lºô¯¸¤W¤U¸ü¤U¨Óªº~

¦ý¦]¬°¥L²Ä¤@¤Ñ¬°¬P´Á¤@¡A§Ú±N¥L­×§ï¬°¬P´Á¤Ñ¡ã¤º®e¤]§ï¬°¦Û¤v»Ý­nªºÅã¥Ü¤è¦¡¡ã

¦ý§Úµo²{¢±¢¯¢°¢¶¦~¢³¤ë¢°¤é´N¨S°ÝÃD¡A¦pªG§ï¨ì¢±¢¯¢°¢¶¦~¢°¤ë´N¤S¿ù¤F¡ã

¦Ó¥B¥L¤½¦¡ªº¼Æ­È¤]·|§ó§ï¡ã¡A¤£ª¾¹D¨ì©³­þ¸Ì¦³»~¡ã¥i§_½Ð¦U«e½úÀ°À°¦£¡ãÁÂÁ¤j®a ¤ë¾ä¥t¦s.zip (14.43 KB)

http://blog.xuite.net/hcm19522/twblog/493230646
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522

­«ÀY¶Ã¨ì§À~¬Oµo¥Í¤°»ò¨Æ¤F¶Ü?

TOP

¦^´_ 3# phoebegin
2003ª©µLIFERROR«ü¥O
=IF(ISERR(MONTH(--($A$1&(INT(COLUMN(B1)/2)+INT((ROW(A1)-1)/6)*7-WEEKDAY($A$1&"1¤é",1)+1)&"¤é"))),"",INT(COLUMN(B1)/2)+INT((ROW(A1)-1)/6)*7-WEEKDAY($A$1&"1¤é",1)+1)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

~¦n¼F®`³á~
§Ú·d¤F¤T¤Ñ~ÁÙ·d¤£©w~
§A¤@¤U¤l´N·d©w¤F~¯uªº«Ü±j

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-3-31 10:26 ½s¿è

¦^´_ 5# phoebegin


    http://blog.xuite.net/hcm19522/twblog/495541260

1-3056.png (20.2 KB)

1-3056.png

1-3056-1.png (16.56 KB)

1-3056-1.png

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

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD