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

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

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

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

¥»©«³Ì«á¥Ñ ­ã´£³¡ª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

¦^´_ 2# Hsieh


    ÁÂÁÂ
joyce

TOP

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

TOP

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

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD