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

TOP

¦^´_ 2# hcm19522

¥¼©R¦W.png
2017-3-20 18:41
­«À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)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD