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

[µo°Ý] ¨D°Ý!!ªí®æ¤¤¤ë¥÷ªº¤ñ¹ï°ÝÃD!!

[µo°Ý] ¨D°Ý!!ªí®æ¤¤¤ë¥÷ªº¤ñ¹ï°ÝÃD!!

²{¦bªí®æ¤¤1998/6/1ªº¦~¤ë¤é·|¥H¤µ¤Ñªº®É¶¡2013/8/26¤U¥h¶]Á`¦@¦³¦hªø¨Ó¿é¥X¡A¬O¤£¬O¥i¥H³]©w¦¨2013/5/5 ¤U¥h¶]¦@¸g¹L¦hªø®É¶¡¨Ó¿é¥X?
ªþ¥óªí®æ¤¤ªºCÄ椽¦¡¬°:
=IF(B2<>"",DATEDIF(B2,TODAY(),"y")&"¦~"&DATEDIF(B2,TODAY(),"ym")&"­Ó¤ë","")
·|¾É­PCÄæ¿é¥X¬° 15¦~2­Ó¤ë

DÄ椽¦¡:
=IF(C2<>"",DATEDIF(B2,TODAY(),"y"),"")
¥u¬Ý¦~¤À¡A¤ë¥÷µL±ø¥ó±Ë¥h

¬O¤£¬O¯à­×§ï¦¨:
A                                B                           C                              D
2013/5/5        1998/6/1           14¦~11­Ó¤ë             14¦~

½Ð°Ý­n¦p¦ó­×§ï?

·s¼W Microsoft Excel ¤u§@ªí.zip (6.89 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2013-8-26 12:29 ½s¿è

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

TOP

¦^´_ 2# p212


    ·PÁ¦^´_!³o¼Ë§ï½T¹ê¥i¥H¨Ï¥Î¤F!¤§«e­×§ïªº®É­Ô¤£ª¾¹D­n§â"()"¤@°_­×§ï±¼¡AÃø©Ç³£¤£·|¦¨¥\!

TOP

¥»©«³Ì«á¥Ñ rszo ©ó 2013-8-26 13:32 ½s¿è

¦]¬°·s¤âÁÙ¦bÃ䪦¤åÃä¹ê²ßªº¶¥¬q¡A¹ï©óIFªº¥ÎªkÁÙ¤£¬O«Ü¼ô±x¡A¥t½Ð±Ð¤@­Ó°ÝÃD¡A­YCÄæ­è¦n¬°14¦~0­Ó¤ë
­n¦h¥[¬Æ»ò­­¨î¤~¯àÅýDÄæ¿é¥X¬°13¦~?¦ý¬O¥u¦³­è¦n¤ë¼Æ¬°0ªº¼Öªº±¡ªp¤~-1¦~¡A¨ä¥L±¡ªp(EX:14¦~1­Ó¤ë¥H¤W)«hºû«ù14¦~

TOP

¦^´_ 4# rszo


    ¶W¹L3¤ÀÄÁ¤£¯à¦A½s¿è¡A³o¸Ì¦A¸É¥R¤@¤U
¥H¤W±¡ªp¦pªG¦A¥[¤@­Ó±ø¥ó:1¦~0­Ó¤ëºû«ù¿é¥X1¦~¡A2¦~0­Ó¤ë¥H¤W¤~Ä~Äò®M¥Î¤W­z±¡ªp­n«ç»ò­×§ï?

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-8-26 13:43 ½s¿è

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

TOP

¤Q¤À·PÁ±zªº¦^´_!
­è­è´ú¸Õ¤F¤@¤U¡A­Y2013/5/5¥i¥HÅý¦³¤p¼ÆÂIªº±¡ªpµo¥Í
¦ý¬O­Y¤é´ÁA2§ï¦¨2013/7/31¡AD5«h·|¿é¥X14.05
³o¼Ë­×§ï¦n¹³¥u¦³¬Y¨Ç¯S©w¤é´Á¯à¤p©ó14(¤p¼Æ¦ì¼Æ¦Û¦æ³]©wµL±ø¥ó±Ë¥hªº¸Ü)
¸É¥R:¥H¤W±¡ªp¦pªG¦A¥[¤@­Ó±ø¥ó:1¦~0­Ó¤ëºû«ù¿é¥X1¦~¡A2¦~0­Ó¤ë¥H¤W¤~Ä~Äò®M¥Î¤W­z±¡ªp
³o¼Ë¤l¦³¨S¦³¨ä¥L¤èªk­×§ï©O?

TOP

¦^´_ 6# p212


¤£¦n·N«ä¡A­è­è¨Sª`·N¨SÂI¨ì¦^´_«ö¶s.
   
¤Q¤À·PÁ±zªº¦^´_!
­è­è´ú¸Õ¤F¤@¤U¡A­Y2013/5/5¥i¥HÅý¦³¤p¼ÆÂIªº±¡ªpµo¥Í
¦ý¬O­Y¤é´ÁA2§ï¦¨2013/7/31¡AD5«h·|¿é¥X14.05
³o¼Ë­×§ï¦n¹³¥u¦³¬Y¨Ç¯S©w¤é´Á¯à¤p©ó14(¤p¼Æ¦ì¼Æ¦Û¦æ³]©wµL±ø¥ó±Ë¥hªº¸Ü)
¸É¥R:¥H¤W±¡ªp¦pªG¦A¥[¤@­Ó±ø¥ó:1¦~0­Ó¤ëºû«ù¿é¥X1¦~¡A2¦~0­Ó¤ë¥H¤W¤~Ä~Äò®M¥Î¤W­z±¡ªp
³o¼Ë¤l¦³¨S¦³¨ä¥L¤èªk­×§ï©O?

TOP

¦^´_ 6# p212


    ³o¬O§Ú­è­è´ú¸Õ¥X¨ÓªºÀÉ®×
¦]¬°¥H«á³£·Q­n¥H¬Y¤ëªº¤ëªì©Î¤ë§À¨Ó°µ¼Ð·Ç®É¶¡¤U¥hrun
¹J¨ì¦pD5©ÎI2ªº±¡ªp«h¦¹¤èªk¤£¾A¥Î¡A¯à¦³¨ä¥L¤èªk¶Ü?


·s¼W Microsoft Excel ¤u§@ªí.zip (7.77 KB)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-8-26 16:20 ½s¿è

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

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD