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

Ãö©ó¤Ñ¼Æ­pºâ°ÝÃD?

Ãö©ó¤Ñ¼Æ­pºâ°ÝÃD?

½Ð°Ý¦U¦ì¤j¤j¡G
¦pªGA1¿é¤J99.12.01...B1¿é¤J=DATEVALUE("99/12/31")-DATEVALUE(SUBSTITUTE(A1,".","/"))+1¤½¦¡
¥i·íA1¿é¤J100.12.01...B1¿é¤J=DATEVALUE("100/12/31")-DATEVALUE(SUBSTITUTE(A1,".","/"))+1¤½¦¡®É
«o¥X²{#VALUE!ªº¿ù»~°T®§?
©Ò¥H½Ð°Ý¤j¤j­n¦p¦ó³]¤½¦¡­pºâ100.12.31-A1Ä檺¤é´Á=¤Ñ¼Æ ??

³o¬O¦]¬°excel¦b§PŪ¤é´Áªº¦~¥÷®É¬O¥H¦è¤¸¦~¬°¥D¦Ó«D¥Á°ê¦~
·í¿é¤J99/1/1  excel·|¦Û°ÊÂন1999/1/1 «D¥Á°ê99¦~(2010)
±ý¥Oexcelª¾¹D¿é¤Jªº¬O¥Á°ê¦~¥÷ªº¤èªk¬O¦b¦~¤§«e¥[r
¨Ò¦p ¿é¤Jr100/1/1  excel·|¦Û°ÊÂন2011/1/1

©Ò¥H«Øijªº¸Ñ¨M¤è¦¡¬°
¥i¥H±N¿é¤J100ªº²ßºD§ï¦¨¿é¤J2011
©ÎªÌ±N¤½¦¡§ï¦¨ =DATEVALUE("r100/12/31")-DATEVALUE("r"&SUBSTITUTE(A1,".","/"))+1
My Blog
http://blog.xuite.net/a8350070

TOP

¦^´_ 2# a8350070


   ¸Õ¤Fa8350070¤j¤jªº¤½¦¡....¥i¥H¤F....ÁÂÁ¤j¤j~~·PÁÂ...,:)

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD