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

[µo°Ý] «ç»òÅã¥Ü¤@¾ã¦~ªº¬P´Á¤»©M¬P´Á¤é¤é´Á

[µo°Ý] «ç»òÅã¥Ü¤@¾ã¦~ªº¬P´Á¤»©M¬P´Á¤é¤é´Á

¦U¦ì¯«¤j¤j:
¤p§Ì§Ú¤£À´EXCELL¡A§Æ±æ¤j¤j­Ì¥i¥HÀ°§Ú¸Ñµª

°²³]: ¦bA1¿é¤J¨Ò: "2013"  ¡A     B1´N·|¥uÅã¥Ü2013¤@¾ã¦~¥÷ªº¬P´Á¤»©M¬P´Á¤é¤é´Á(¨Ò: "11¤ë02¸¹¬P´Á¤»")

½Ð°Ý³o­n«ç»ò¿é¤J¨ç¼Æ©O   ½Ð¤j¤j­Ì±Ð§Ú~"~
¤£·|EXCALLªº²Â³J

§A­n§â¤@¦~¤¤©Ò¦³ªº¬P´Á¤»¤é³£Åã¥Ü¦b¤@­ÓÀx¦s®æ¤º?

½Ð»¡²M·¡¤@ÂI
ss

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2013-11-2 15:47 ½s¿è

B1 =IF(ROW(A1)=1,DATE(A$1,1,)+MIN(MATCH({6,7},WEEKDAY(DATE(A$1,1,{1,2,3,4,5,6,7}),2),)),IF(WEEKDAY(INDIRECT("R[-1]C",),2)=6,1,6)+INDIRECT("R[-1]C",))
¤U©Ô½Æ»s¤½¦¡

®æ¦¡¦Û­q¬° mm¤ëdd¸¹aaaa
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# prince0413

¦pªG§A·|¥Î°}¦C¤½¦¡¡A´£¨Ñ¤U¦¡°Ñ¦Ò

¥ý¿ï¾Ü B1:B105 Àx¦s®æ
½Æ»s¤U¦C¤½¦¡¶K¦Üªí³æ¤W¤è¤½¦¡½s¿è°Ï¤º
=TEXT(SMALL((WEEKDAY(DATE(A1,1,ROW(1:366)),2)<6)*9^9+DATE(A$1,1,ROW(1:366)),ROW(1:105)),"[<"&DATE(A1,12,31)&"]mm¤ëdd¸¹aaaa;")

¨Ï¥Î¤TÁä¿é¤J¤è¦¡(¥ý«öCTRL+SHIFT¦A«öENTER¤TÁä»ô«ö¤è¦¡¿é¤J¤½¦¡)
¿é¤J«á¤½¦¡«e«á "{.....¤½¦¡.....}" ¥Î { }¨í¦í¡AÅã¥Ü¦p¤Uªí¦¡¿é¤J¦¨¥\
{=TEXT(SMALL((WEEKDAY(DATE(A1,1,ROW(1:366)),2)<6)*9^9+DATE(A$1,1,ROW(1:366)),ROW(1:105)),"[<"&DATE(A1,12,31)&"]mm¤ëdd¸¹aaaa;")}
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# sunnyso



¦p¤W¹Ï
¨Ã¤£¬OÅã¥Ü¦b¦P¤@­ÓÀx¦s®æ­ò
¤p§Ì¬O­n¬D¿ï¥X¤@¦~¥÷ªº¤»¤é°²´Á
µM«á¥ÎA4¦L¥Xµô°Å~

·PÁ¦U¦ì¤j¤j­Ì±Ð¾Ç    ¦³¬Æ»ò¤è¦¡¤ñ¸û®e©öÀ´©O?
¤£·|EXCALLªº²Â³J

TOP

¦^´_ 6# prince0413

¤ë¥÷¦p¦ó©w?

·í«e¤ë¥÷? ÁÙ¬O¥Î¥t¤@Àx¦s®æ³]©w?
ss

TOP

¦^´_ 7# sunnyso


¤j¤j±z¦n

¥u·|¦bA1¿é¤J¦~¥÷

µM«á§â¸Ó¦~1¤ë~12¤ë¨C­Ó¤ëªº°²¤é(¤»¡B¤é)³£Åã¥Ü¥X¨Ó³o¼Ë

¤@±ÆÅã¥Ü(¤»)    ¹j¾À¥t¤@±ÆÅã¥Ü(¤é)
¤£·|EXCALLªº²Â³J

TOP

¦^´_ 4# ML089


·Ó¤j¤j±zªºµ{¦¡¿é¤J¬O¦¨¥\ªº

¦ý¥i§_½Ð±Ð¤@¤U¡A¦pªG­nÅã¥Ü¨â±Æ(¤@±ÆÅã¥Ü"¬P´Á¤»" ¡A¹j¾À¤@±ÆÅã¥Ü"¬P´Á¤é")
¦p¤W¹Ï

³o¼Ë­n«ç»ò³]©w©O

§Ú¦³¬ã¨s¹L¤j¤jªº¤½¦¡ ¡A¦ý§Ú¬O·s¤â©Ò¥H¬Ý¤£¤ÓÀ´IF§PÂ_¦¡   ~"~
¤£·|EXCALLªº²Â³J

TOP

Sonny.rar (16.43 KB) ¦^´_ 5# prince0413
ss

TOP

¦^´_ 9# sunnyso

¤j¤j¤£¦n·N«ä

§Ú¬Q¤é­è¥[¤J½×¾Â±b¸¹¨S¦³Åv­­¯à°÷¤U¸üªþ¥ó

¥i§_±H¦Ü([email protected])¦¹«H½cµ¹§Ú©O  ~"~
¤£·|EXCALLªº²Â³J

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD