- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-1-21 11:38 ½s¿è
¦^´_ 1# kimo5566
AÄæ(¦pÀx¦s®æA1¬°1020822)»PBÄæ(¦pÀx¦s®æB1¬°20131231)¬Ò¬°¡u¤å¦r®æ¦¡¡v¤é´Á¡AÀx¦s®æC1¿é¤J
=DATEDIF(DATE(LEFT(A1,3)+1911,MID(A1,4,2),RIGHT(A1,2)),DATE(LEFT(B1,4),MID(B1,5,2),RIGHT(B1,2)),"M")
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I |
|