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

[µo°Ý] ¤é´Á¬Û´î

[µo°Ý] ¤é´Á¬Û´î

[A1]=¤µ¤Ñ¤é´Á¡]=TODAY¡^
[B1]=¨Ò¦p85.01.08¡]¥i¿é¤J¡]ÀH®É§ó°Ê¡^¡^
[C1]=µ²ªG¡H

¦p¦ó¥ÎVBA­pºâ¤é´Á¬Û´îµª®×????

³o­Ó¥Î¤½¦¡§ó²³æ
c1==a1-b1

TOP

¦^´_ 2# ikboy


    ¦¹¤è¦¡¤£¹ï...
»Ý±ÄVBA¼Ò¦¡..
¥B¤µ¤é¤é´Á¬°104/08/12
   ¿é¤J¤é´Á¬°85.08.01
®t²§¬°¡¨¡þ¡¨¤Î¡¨.¡¨
­n¦p¦ó¥Î¢ä¢Ð¢Ï¥h¬Û´î©O¡H¡H¡H¡H

TOP

¦^´_ 3# sillykin


    ¯à§_À°¸Ñµª©O???

TOP

¥ý§âB1ªº¤é´ÁÂà´«¦¨¸òA1ªº®æ¦¡¬Û¦P¦A¬Û´î©O

TOP

DT = "85.10.1" '¥Á°ê
MsgBox "¦è¤¸¡G" & DateValue(Replace("r" & DT, ".", "/"))

TOP

¦^´_ 6# ­ã´£³¡ªL


    ÁÂÁ¤j¤jªº¦^ÂФΫü¾É..,¤p§Ì¸Õ¸Õ..·P®¦

TOP

¦^´_ 7# sillykin


    ÁÂÁ¤j¤j..
¤p§Ì¥i¯à¨S¦³»¡²M·¡
A1=TODAY()   ; ¤é´Á®æ¦¡¬° 104/10/1
A2= 77/8/7
A3=µ²ªG       ;(¬°´X¦~´X¤ë´X¤é)¥Á°ê®æ¦¡Åã¥Ü


©êºp,»s³y¤j¤jªº§xÂZ

TOP

¦^´_ 8# sillykin


A1=TODAY()
A2= 77.8.7

A3:=A1-SUBSTITUTE("R"&A2,".","/")      ¬O¡e¶Z¤µ´X¤Ñ¡f¦Ó¤£¬O¡e´X¦~´X¤ë´X¤é¡f

TOP

¦^´_ 9# ­ã´£³¡ªL


    ÁÂÁ¤j¤jªº¦^ÂÐ....¤p§Ì¤x¤F¸Ñ

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD