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

[µo°Ý] ­pºâ¥XÁÙ¦³´X­Ó¤ë¨ì´Á

[µo°Ý] ­pºâ¥XÁÙ¦³´X­Ó¤ë¨ì´Á

¥»©«³Ì«á¥Ñ p0078 ©ó 2010-8-29 15:56 ½s¿è

ªþ¥ó¦³»~­«·s¤W¶Ç

book.rar (7.7 KB)

¦^´_ 1# p0078
­pºâ¥XÁÙ¦³´X­Ó¤ë¨ì´Á    E2=DATEDIF(A$2,C2,"m")  ¤½¦¡¤U©Ô
­pºâ¥XÁÙ¦³¦h¤Öª÷ÃB¥¼Ãº  F2==SUMIF(E:E,"<>0",D:D)
http://share.tpc.edu.tw/_vti_bin/help/1028/sts/html/ldatedif.htm

TOP

¦^´_ 2# GBKEE


    GBKEE§A¦n
¬°¦ó§Ú§ä¤£¨ìDATEDIF³o­Ó¨ç¼Æ

TOP

ªþ¥ó¦³§ó§ï
GBKEE
¦p¥Î¸Ó¤½¦¡E2=DATEDIF(A$2,C2,"m") ·|¤Ö¤@­Ó¤ë
°_¤é¥Î2010/08/01²×¤î¤é¥Î2010/09/01
À³¸ÓÁÙ¦³2010/09/01¥¼¨ì´Á

TOP

¦^´_ 4# p0078


    ½Ð°Ý­n¦p¦ó¨Ï¥Î­pºâ2010¦~¥u³Ñ´X¤Ñªº¨ç¼Æ©O

TOP

¦^´_  p0078


    ½Ð°Ý­n¦p¦ó¨Ï¥Î­pºâ2010¦~¥u³Ñ´X¤Ñªº¨ç¼Æ©O
cappuccino22 µoªí©ó 2010-8-29 18:22



¸Õ¸Õ
=date(2011,1,1)-today()
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦n¥Îªº¨ç¼Æ
¥i¬O¦]¬°¤p§ÌEXCELª©¥»ªº°ÝÃD
¨S¦³DATEDIF³o­Ó¨ç¼Æ©O
½Ð°ÝÁÙ¦³¤°»ò¤èªk©O

TOP

¦^´_ 7# gn00487767
DATEDIF¨ç¼Æ¤£¤Àª©¥»³£¤£·|¥X²{¦b¨ç¼Æ²M³æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh

¦A¦¸·PÁÂHsieh ¤j¤j
¤p§Ì´ú¸Õ¹L ¥\¯à¥¿±` ¥u¬O¨S¦³»¡©ú ¤p§ÌµLªk¥Î³o­Ó¤èªk°µ°Ñ¦Ò
¤p§Ì»Ý­n§â¤@­Ó¤é´Áªº¤ë¼Æ ¼W¥[¤£µ¥ªº¤ë¥÷
¦C¦pAÄ欰¤é´Á
    A2ªº¤é´Á¬°2010/11/15
      BÄ欰§Ú­n¼W¥[ªº¤ë¥÷¼Æ
    B2ªº¼Æ¦r¬°3
      CÄæ¬O§Ú­nªºµ²ªG
    C2«hÅã¥Ü¬°2011/02/15
(¼W¥[«áÁÙ­n­n¦Û°Ê¼W¥[¦~)
¤p§Ì¦³°µ¥X¤@­Óªí¦ý¬O«ÜÂø¶Ã
©Ò¥H·Q°Ý¬Ý¬Ý¬O¤£¬O¦³¤ñ¸û²³æªº¤èªk
¦p¤U

¤é´Á­pºâ.rar (8.38 KB)

TOP

¦^´_ 9# gn00487767

¤u¨ã/¼W¯q¶°
¤Ä¿ï¤ÀªR¤u¨ã½c
D3=EDATE(A3,B3)
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD