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

­pºâ¨â­Ó¤é´Á¤§¶¡¬Û®t´X­Ó¤ë(µª®×¦pCÄæ)

­pºâ¨â­Ó¤é´Á¤§¶¡¬Û®t´X­Ó¤ë(µª®×¦pCÄæ)

­pºâ¨â­Ó¤é´Á¤§¶¡¬Û®t´X­Ó¤ë(µª®×¦pCÄæ)
joyce

¦^´_ 1# leiru


    C2=DATEDIF(INT(A2/10000)+1911&"/"&MID(A2,4,2)&"/"&RIGHT(A2,2),INT(B2/10000)+1911&"/"&MID(B2,4,2)&"/"&RIGHT(B2,2),"m")+1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# Hsieh


    ÁÂÁÂ
joyce

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2018-4-16 18:53 ½s¿è

=DATEDIF(TEXT(A2,"!r0-00-00")-1,TEXT(B2,"!r0-00-00"),"m")
=DATEDIF(TEXT(A2+19110000,"0-00-00")-1,TEXT(B2+19110000,"0-00-00"),"m")

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD