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

¦p¦ó­pºâ¾lÃB

¦p¦ó­pºâ¾lÃB

½Ð°Ý¦p¦ó­pºâÀɮפºb6¤Îb7Àx¦s®æªºµª®×,¤w±N±ø¥ó¼g¦bÀx¦s®æ¤º,
³Â·Ð¦U¦ì¤F,ÁÂÁÂ

¦p¦ó­pºâ°h¾lÃB.rar (1.95 KB)

joyce

¦^´_ 1# leiru

B2,B3,B5«D¥¿½T¤é´Á®æ¦¡,½Ð±Ä¥Î¥¿½T¤é´Á®æ¦¡
(°Ñ·Ó ®æ¦¡/Àx¦s®æ ¤ºªº¤é´Á®æ¦¡)

B6=B5-B2-1
B7=ROUND(B4-ROUNDDOWN(B4/365,2)*B6,0)

TOP

¦^´_ 2# register313


    µª®×¨S¿ù,¥t¥~,§Ú¦³´£¨ì,¦³¥i¯à,­Y°h¯²¤é©M¹wú°_©l¤é¦P¤é´Á,¬O§_¥i¥H¦bb6Àx¦s®æÅã¥Ü¬°0¤Ñ,b7Àx¦s®æ´NÅã¥Üb4Àx¦s®æªº­È
joyce

TOP

¦^´_ 3# leiru

B6=IF(B2=B5,0,B5-B2-1)
B7=IF(B2=B5,B4,ROUND(B4-ROUNDDOWN(B4/365,2)*B6,0))

TOP

¦^´_ 4# register313


    to register313 ,·PÁ±zªº¦^ÂÐ,
   §Ú²{¦b¤S¸I¨ì¥tºØ±ø¥ó°h¶O,½Ð¨£Àɮפºsheet2
   b7Àx¦s®æ¤@¼Ë¬Ob5-b2-1,¥i¬O³o¦¸­n¥H:´X­Ó¤ë¤S´X¤ÑÅã¥Ü
   b8Àx¦s®æ=B7*¤ë¼Æ+round(B7*¤Ñ¼Æ/30¤Ñ,0)
   b9Àx¦s®æ=B4-B8,¥i¬O­Y¸I¨ìb5Àx¦s®æ¤é´Á»Pb2Àx¦s®æ¤é´Á¬Û¦P®É,´NÅã¥Üb4Àx¦s®æªº­È

¤£¦n·N«ä,¤@ª½³Â·Ð

¦p¦ó­pºâ°h¾lÃB.rar (4.07 KB)

joyce

TOP

¦^´_ 5# leiru

B7=DATEDIF(B2,B5,"M")&"¤ë/"&DATEDIF(B2,B5,"MD")-1&"¤é"
B8=B6*DATEDIF(B2,B5,"M")+ROUND(B6*(DATEDIF(B2,B5,"MD")-1)/30,0)
B9=IF(B2=B5,B4,B4-B8)

TOP

¦^´_ 6# register313


    ÁÂÁÂregister313¦^ÂÐ,³Ì«á¤@­Ó¤p°ÝÃD´£¥X,Àɮפº¤u§@ªí¤ºªºÀ³¦¬¤Ñ¼Æ,ºâ¥X¨Óªºµª®×¤£¤Ó¹ï,
   °ÝÃD½Ð¨£¤u§@ªí¤º»¡©ú.ÁÂÁÂ

¦p¦ó­pºâ°h¾lÃB.rar (8.71 KB)

joyce

TOP

¦^´_ 7# leiru

A,B 2¼Æ¬Û´î
(1)ÀY§À³£¤£ºâ => A-B-1
(2)¨D2¼Æ®t¶Z  =>A-B
(3)ÀY§À³£ºâ     => A-B+1

§A¤@¶}©l´N¦³-1¤F,§Ú¬O°t¦X§Aªº => (1)A-B-1
²{¦b·Ó§Aªº»¡©ú                 => (2)A-B

§âSHEET1,SHEET2À³¦¬¤Ñ¼Æ¸Ìªº¤½¦¡-1®³±¼

TOP

¦^´_ 8# register313


    ³o¼Ë§ÚÁA¸Ñ¤F,«D±`·PÁ±z
joyce

TOP

¦^´_ 8# register313


    §Ú¤S­n¨Ó½Ð±Ð¡A¤§«eªºÀɮ׬O°w¹ï¤@¦~ú¡A­Y¦³¤À©uú©Î¥b¦~ú¡A«hÀx¦s®æ­n¦p¦ó¦Û°Ê§PÂ_©O

¦p¦ó­pºâ°h¾lÃBV2.zip (8.73 KB)

joyce

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD