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

[µo°Ý] ¤Þ¼Æ¤£¬°¿ï¾Ü©Ê(optional)

¦^´_ 2# av8d
Month(Date) & "/" & Day(Date - 2)  ¦pªG¤µ¤Ñ¬O8/1  
-2¤ÑÀ³¸Ó¬O7/30    ¦ý¬O¥L«oÅã¥Ü8/30


¨ç¼Æªº¥Îªk§AÁÙ¨S¦³§Ë²M·¡
  1. Sub Ex()
  2. [a1] = Date - 2
  3. [a2] = DateSerial(Year(Date), Month(Date), Day(Date)) - 2
  4. [a3] = DateValue(Year(Date) & "/" & Month(Date) & "/" & Day(Date)) - 2
  5. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD