p212

¦^´_ 1# rszo
¥H±z´£¨Ñªº½d¨Ò°õ¦æ­×§ï¡G
1¡BA2Àx¦s®æ¿é¤J2013/5/5
2¡BC2Àx¦s®æ¤½¦¡­ì¦³ªºTODAY()§ï¦¨A2§Y¥i¡AC2Àx¦s®æ­×§ï«á¦p¤U¦C¤½¦¡¡G
=IF(B2<>"",DATEDIF(B2,A2,"y")&"¦~"&DATEDIF(B2,A2,"ym")&"­Ó¤ë","")
3¡BD2Àx¦s®æ¤½¦¡­×§ï¤è¦¡¥ç¦P
=IF(C2<>"",DATEDIF(B2,A2,"y"),"")
½Ð°Ý³o¼Ë¥i¥H¶Ü¡H

p212

¦^´_ 4# rszo
D2Àx¦s®æ¤½¦¡­×§ï¬°
=IF(C2<>"",YEARFRAC(B2,A2),"")
³o¼Ë¥i¥H¶Ü¡H
ps.¤p¼Æ¦ì¼Æ½Ð¦Û¦æ³]©w

p212

¦^´_ 9# rszo
½Ð°Ý
¦bstart_date¬°1999/7/13¥Bend_date¬°2013/7/31®É¡A¨Ï¥ÎYEARFRAC¨ç¼Æºë·Ç¦a­pºâ¸Ó¤G¤é´Á¬Û®t¬°¡u14.05¡v¦~¤§±¡ªp¤U¡A
±z­nªºµª®×¬O¡u13¡v¦Ó¤£¬°¡u14¡v¡H§í¥t¬°¨ä¥Lµª®×¡H
¥i§_¦A±N±ø¥ó¾ã²z¤@¤U(¦p½d¨ÒÀÉ¥[µùÄæ¦ì¦WºÙ¡B±Ô­z¥Î·Nµ¥)¥H¨Ñ¤j¹Ù¨à¤@»ô°Q½×¡H
ÁÂÁ¡I

p212

¦^´_ 9# rszo
©Ó10#¦^ÂÐ_±z­nªºµª®×¬O¡u13¡v¦Ó¤£¬°¡u14¡v¡H
½Ð°Ñ¦Ò¤U¦C§@ªk
1¡B½Ð¦b9#½d¨ÒÀɤ§D2Àx¦s®æ¿é¤J
=IF(C2="","",IF(DATEDIF(B2,$A$2,"ym")=0,INT(YEARFRAC(B2,$A$2)-1),INT(YEARFRAC(B2,$A$2))))
¦V¤U½Æ»s¤½¦¡
2¡B½Ð¦b9#½d¨ÒÀɤ§J2Àx¦s®æ¿é¤J
=IF(I2="","",IF(DATEDIF(H2,$G$2,"ym")=0,INT(YEARFRAC(H2,$G$2)-1),INT(YEARFRAC(H2,$G$2))))
¦V¤U½Æ»s¤½¦¡

p212

¦^´_ 13# rszo
¥H12#´£¨Ñªºªþ¥óÀɭק綠¦¡
½Ð¦bD3Àx¦s®æ¿é¤J
=IF(C3="","",IF(AND(DATEDIF(B3,A3,"y")>1,DATEDIF(B3,A3,"ym")=0),INT(YEARFRAC(B3,A3)-1),INT(YEARFRAC(B3,A3))))

p212

¦^´_ 16# rszo
1¡BYEARFRAC(start_date,end_date,basis)¨ç¼Æ¥Î¥Hºë·Ç¦a­pºâ¨â­Ó¤é´Á¬Û®t¦h¤Ö¦~(§t¤p¼Æ)
¨ä¤¤basis«Y«ü©Ò±Ä¥Îªº¤é­p§Q°òªºÃþ«¬¡A­YµL¯S®í»Ý¨D¡A«Øijbasis±Ä¥Î0©Î¬Ù²¤§Y¥i¡C
½Ð¨Ì±zªº»Ý¨D¿ï¾Übasis­×§ï
basis-----------¤é­p§Q°òªºÃþ«¬
0©Î¬Ù²¤--------US (NASD) 30/360
1---------------¹ê»Ú¤Ñ¼Æ/¹ê»Ú¤Ñ¼Æ
2---------------¹ê»Ú/360
3---------------¹ê»Ú/365
4---------------¼Ú¬w 30/360

2¡Bbasis±Ä¥Î¡u1¡v¥i¯à¸û¶Kªñ±zªº»Ý¨D¡A©Ó13#¤§D3Àx¦s®æ¤½¦¡­×§ï°Ñ¦Ò¦p¤U¡C
=IF(C3="","",IF(AND(DATEDIF(B3,A3,"y")>1,DATEDIF(B3,A3,"ym")=0),INT(YEARFRAC(B3,A3,1)-1),INT(YEARFRAC(B3,A3,1))))