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

[µo°Ý] ¤ëªº¬Û¥[´î ?

¦^´_ 3# t8899
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. If Target.Address = "$A$1" Then [A2] = Format(DateAdd("m", [A1], Date), "e/mm")
  3. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD