ªð¦^¦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 : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD