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

½Ð°ÝÀx¦s®æ®æ¦¡°ÝÃD

½Ð°ÝÀx¦s®æ®æ¦¡°ÝÃD

½Ð°Ý¦U¦ì¥ý¶i¡G

¤p§Ì¤½¥q¸ê®Æ±q¨t²Î§ì¤U¨Ó¤§«á¡A·Q­nºâ¦~¸ê

¦ý¬O®æ¦¡°ÝÃD¤@ª½§xÂZ§Ú

«ç»ò½Õ «ç»ò°µ  AÄdªº®æ¦¡ Á`¬OµLªk§PÂ_

¥i§_½Ð¦U¦ì¥ý¶i À°¦£¬Ý¤@¤U°ÝÃD¥X¦b­þ??


·P¿E¤£ºÉ

¦~¸ê.zip (12.21 KB)

=DATEDIF(REPLACE(A2,1,3,LEFT(A2,3)+1911),B2,"Y")

TOP

ÁÂÁÂANGELA ¤j¤j~
¤£¹L§ÚÁÙ¬O¦³ÂI¬Ý¤£À´......

¨º¦pªG§Ú­n¸Ô²Ó­n´X­Ó¤ë©O??
³o­Ó¤S¸Ó«ç»ò¼g?

PS~¯uªºÁÙ·d¤£¤ÓÀ´

TOP

=DATEDIF(REPLACE(A2,1,3,LEFT(A2,3)+1911),B2,"Y")&"¦~"&DATEDIF(REPLACE(A2,1,3,LEFT(A2,3)+1911),B2,"YM")&"­Ó¤ë"

TOP

ÁÂÁ¦U¦ìªº«ü¾É~
¨ü¥Î¤£¶i

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD