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

(¤w¸Ñ¨M)Ãö©óDATEDIF³o¦U¨ç¼Æ

(¤w¸Ñ¨M)Ãö©óDATEDIF³o¦U¨ç¼Æ

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:11 ½s¿è

½Ð°ÝDATEDIFªº¨ç¼Æ¬O2003ª©´N¦³ªº¶Ü?
ÁÙ¬OÁôÂ꺨ç¼Æ?
§ÚªºEXCEL§ä¤£¨ì³o¦U¨ç¼Æ¦ý¬O¥i¥H¥Î¡A³o¬O¥¿±`ªº¶Ü?



Doc1.rar (17.95 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 2# register313


    ³o¦U§Ú¦bºô¸ô¤W¦³¬d¨ì
   ¥u¬O«Ü¦n©_¬°¤°»ò¦b¨ç¼Æ¦Cªí¸Ì­±§ä¤£¨ì¤]¨S»¡©ú¦pµo°Ý¸Ì­±ªºªþÀÉ
   ¦ý¬O«o¥i¥H¥Î
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 1# freeffly
³o­Ó¨ç¼Æ¥H«e´N¦³,¬OÁôÂèç¼Æ,´£¨Ñ¦¹¨ç¼Æ¬O¬°¤F»P Lotus123¬Û®e.
¥\¯à¬O­pºâ¨â­Ó¤é´Á¤§¶¡ªº¤Ñ¼Æ¡B¤ë¼Æ©Î¦~¼Æ¡C

¨Ò¦pA1=2000/2/15
     B1=2003/9/25
     C1=DATEDIF(A1,B1,"Y") & "¦~" & DATEDIF(A1,B1,"YM") & "¤ë" & DATEDIF(A1,B1,"MD") & "¤é"
        =3¦~7¤ë10¤é

¦]µL¤U¸üÅv­­,¤£ª¾§A­n¤°»ò.

TOP

¦^´_ 4# alvinbluetw


    §Ú¥u¬O·Qª¾¹D¥¦¬OÁôÂèç¼Æ¶Ü?
     ¨ºÁÙ¦³¨ä¥LªºÁôÂèç¼Æ¶Ü?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 5# freeffly


§Ú¬d¹L ÁÙ¦³
¦ý¬O ¦]¬°§Ú¨S¦³¥Î©Ò¥H§Ñ¤F

TOP

¦^´_ 6# mustang


    datedif¨ç¼Æ¡BNUMBERSTRING¨ç¼Æ¡BDATESTRING¨ç¼Æ¡BPhonetic¨ç¼Æ³o´X¦UÀ³¸Ó´N¬OÁôÂèç¼Æ¦b¨Ó´N¬O¥¨¶°ªíªº¨ç¼Æ
   ¤£ª¾¹D¦³¨S¦³¿òº|¡A¦n¹³³£¥i¥H¥Î¨ä¥L¤è¦¡¹F¨ì¤W­±ªº¨ç¼Æµ²ªG
   ¬O³o¦U­ì¦]¤~¨S¦³¤½§G¶Ü?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD