ªð¦^¦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

¦^´_ 14# leiru

B7=ROUNDDOWN(B5/DATEDIF(B3,B4+1,"M"),0)

TOP

¦^´_ 11# register313


    register313¤j®v
½Ð°Ý§Ú®M³o¤½¦¡,§ó§ï°_¨´¤é,µo²{µª®×¤£¹ï,´f½Ð«ü±Ð.

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

joyce

TOP

·PÁÂregister313¤ÎHsieh¨â¦ì¤j®v,­è¤~¸Õ¤F,µª®×³£¥¿½T,ÁÂÁÂ
TO Hsieh:°h¯²¤é·í¤Ñ¬O­n¦¬¶Oªº.
joyce

TOP

¦^´_ 10# leiru


B6=ROUNDDOWN(B4/DATEDIF(B2,B3+1,"M"),0)
¨ä¤¤B7À³¦¬¤Ñ¼Æ¸òB8À³¦¬ª÷ÃBÀ³¸Ó¦Ò¼{°h¯²·í¤é¬O§_À³¸Ó¦¬¶O
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-5-15 17:58 ½s¿è

¦^´_ 10# leiru


1.     B6=ROUNDDOWN(B4/12,0)
  => B6=ROUNDDOWN(B4/((YEAR(B3)-YEAR(B2))*12+MONTH(B3)-MONTH(B2)),0)
       ¦~ú:¬õ¦r=12
       ¥b¦~ú:¬õ¦r=6
       ©uú:¬õ¦r=3
2.¨ä¥LÀx¦s®æÀ³¸Ó¤£¥Î­×¥¿§a
3.Àˬd´ú¸Õ¬Ý¬Ý

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

¦^´_ 8# register313


    ³o¼Ë§ÚÁA¸Ñ¤F,«D±`·PÁ±z
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

¦^´_ 6# register313


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

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

joyce

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD