register313

¦^´_ 1# leiru

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

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

register313

¦^´_ 3# leiru

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

register313

¦^´_ 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)

register313

¦^´_ 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®³±¼

register313

¦^´_ 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´ú¸Õ¬Ý¬Ý

register313

¦^´_ 14# leiru

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