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

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

¦^´_ 9# sunnyso


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

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

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

TOP

¦^´_ 8# prince0413
¦pªG§A¬OEXCEL¥Í¤â¡A±N¤½¦¡©î¸Ñ¦¨2³¡¤À¡AÀY¤@¤Ñªº¬P´Á¤»¤Î¬P´Á¤é¥Î¤H¤u¿é¤J¡A«á­±¤é´Á´N¬O«e¤é´Á¥[7¤Ñ
¥t¥~EXCEL­Y¥Îªº¦X¨ÖÀx¦s®æ·|¨Ï¤½¦¡½ÆÂø¤Æ¡A«Øij§ï¬°¤U¹Ï



B2 =DATE(B1,1,1)

¾ï¦â°Ï¤½¦¡
C3¿é¤J²Ä¤@­Ó¬P´Á¤»¤é´Á©Î¥Î¤U¦C¤½¦¡
C3 =B2+MOD(6-WEEKDAY(B2,2),7)

D3¿é¤J²Ä¤@­Ó¬P´Á¤é¤é´Á©Î¥Î¤U¦C¤½¦¡
D3 =B2+7-WEEKDAY(B2,2)

¶À¦â°Ï¤½¦¡
¨C­Ó¬P´Á¤»¦Ü¬P´Á¤»©Î¬P´Á¤é¦Ü¬P´Á¤é¶¡³£¹j7¤Ñ¡A©Ò¥H¥Î¤W®æ¤é´Á¥[7¤Ñ´N¥i
C4 =C3+7
¥k©Ô¤U©Ô½Æ»s¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 20# ML089


·Ó¤j¤jªº¤½¦¡¥Î¬O¦¨¥\ªº

¥u¬O¤ñ¸û¤£À´ªº¬OB2Àx¦s®æªº·N¸q

¬O­n¥Î¨ÓÀ°§Uºâ¤»¤éªº°_©l­È¶Ü?

ÁÂÁ¤j¤jªº¸Ñµª~
¤£·|EXCALLªº²Â³J

TOP

¦^´_ 5# prince0413

D3=DATE($A$3,1,1)+6-WEEKDAY(DATE($A$3,1,1),2)+INT((ROW($A1)-1)/3)*7
E3=DATE($A$3,1,1)+7-WEEKDAY(DATE($A$3,1,1),2)+INT((ROW($A1)-1)/3)*7
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 13# prince0413

B2 =DATE(B1,1,1)
¥u¬O­ì¥ý¦b´ú¸Õ¦UºØª¬ªp¥Î¡A§A¥i¥H±N¸Ó¨ç¼Æ©ñ¨ìC3¡BD3¤½¦¡¤¤¡A¦p¤U

¾ï¦â°Ï¤½¦¡
C3¿é¤J²Ä¤@­Ó¬P´Á¤»¤é´Á©Î¥Î¤U¦C¤½¦¡
C3 =B2+MOD(6-WEEKDAY(B2,2),7)
§ï¬°
C3 =B2+MOD(6-WEEKDAY(DATE(B1,1,1),2),7)

D3¿é¤J²Ä¤@­Ó¬P´Á¤é¤é´Á©Î¥Î¤U¦C¤½¦¡
D3 =B2+7-WEEKDAY(B2,2)  
§ï¬°
D3 =B2+7-WEEKDAY(DATE(B1,1,1),2)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 14# Hsieh


D3¤½¦¡¹J¨ì 1/1¬O¬P´Á¤é®É·| -1 ¤Ñ¡A·|Åܦ¨¥h¦~ªº12/31
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 15# ML089


ÁÂÁ¤j¤j«ü¾É
¤£·|EXCALLªº²Â³J

TOP

¯uªº«Ü¼F®`~¹ï§Ú¤]«Ü¦³À°§U³á~ÁÂÁÂ~

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD