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

[µo°Ý] ¨ì´Á¤é ¦~¤ë¤é­pºâ

[µo°Ý] ¨ì´Á¤é ¦~¤ë¤é­pºâ

½Ð°Ý¦U¦ì°ª¤â

¤wª¾»s³y¤é¦p¦ó¥Î¤½¦¡­pºâ¥X¨ì´Á¤é

¤Ñªº¨ì´Á¤éÁÙ²³æ¼u¬O¸I¤W¦~¤ë´N¦³³Â·Ð¤F

³Â·Ð¦U¦ì±Ð¾É¤F

¨ì´Á¤é.rar (7.71 KB)

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-10-26 12:42 ½s¿è

¦~--ºâ´X¤Ñ??
¤ë--ºâ´X¤Ñ??
±N"¦~¤ë¤é"¤À¶}¤T­ÓÄæ¦ì¿é¤J§a!
¥t¥~, ±N¦X¨ÖÄæ¦ì¨ú®ø, ªí®æÀ³ÁקK¤£¥²­nªº¦X¨Ö~~


  
¸Õ¸Õ~~
=DATE(YEAR(E2)-LOOKUP(1,-(RIGHT(LEFT(D2,FIND("¦~",D2&"¦~")-1)&".0",{1,2,3,4,5}))),MONTH(E2)-LOOKUP(1,-(RIGHT(LEFT(D2,FIND("­Ó",D2&"­Ó")-1)&".0",{1,2,3,4,5}))),DAY(E2)-LOOKUP(1,-(RIGHT(LEFT(D2,FIND("¤Ñ",D2&"¤Ñ")-1)&".0",{1,2,3,4,5}))))

TOP

«D±`·PÁÂ2¦ì ¤Q¤À¦³¥Î

TOP

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