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

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

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

DateSerial(Year(Date), Month(Date), Day(Date) - 1)

§Ú·Q§ï¼g¦¨

DateSerial(Month(Date), Day(Date) - 1)

«o¥X²{"¤Þ¼Æ¤£¬°¿ï¾Ü©Ê(optional)

«ö¤U»¡©ú«á~
¥X²{¤@­Óºô­¶¿ù»~ªºµøµ¡
¦æ: 168
¿ù»~: Automation ¦øªAµ{¦¡µLªk²£¥Íª«¥ó

¤Þ¼Æ¤£¬°¿ï¾Ü©Ê (¿ù»~ 449)
½Ð°Ñ¾\     ¯S©Ê

¤Þ¼Æªº¼Æ¦r©M«¬ºA¥²¶·»P¹w´Á¬Û²Å¡C¦¹¿ù»~¦³¥H¤Uªº°_¦]©M¸Ñ¨M¤èªk¡G

¤Þ¼Æªº¼Æ¦r¤£¥¿½T¡C
´£¨Ñ©Ò¦³¥²­nªº¤Þ¼Æ¡A¨Ò¦p¡ALeft ¨ç¼Æ»Ý­n¨â­Ó¤Þ¼Æ¡F²Ä¤@­Ó¥Nªí­n³B²zªº¦r¤¸¦r¦ê¡A²Ä¤G­Óªí¥Ü±q¦r¦ê¥ª¤è¶Ç¦^ªº¦r¤¸¼Æ¡C¦]¬°µLªk¿ï¾Ü­n¤£­n¥[¡A©Ò¥H¥²¶·¥þ³¡³£µ¹¤~¦æ¡C

¬Ù²¤ªº¤Þ¼Æ¬°«D¿ï¾Ü©Êªº¡C
¥u¦³©I¥sªº¬O¨Ï¥ÎªÌ¦Û­qµ{§Ç¡A¥Bµ{§Ç¤¤«Å§i¤Þ¼Æ¬° Optional¡A¤~¥i¥H¬Ù²¤¤Þ¼Æ¡C±z¥i¥H¦b©I¥s®É´£¨Ñ©Ò¦³¥²­nªº¤Þ¼Æ¡A©Î¬O±N°Ñ¼Æ«Å§i¬° Optional¡C

¸Ô²Ó¸ê°T¡A¥i¿ï¨ú¦³ºÃ°Ýªº¶µ¥Ø¨Ã«ö¤U F1 (¦bWindows¤¤) ©Î HELP (¦bMacintosh¤W)¡C

¦^´_ 1# av8d


    ¶i¶¥°ÝÃD
Month(Date) & "/" & Day(Date - 2)

¦pªG¤µ¤Ñ¬O8/1

-2¤ÑÀ³¸Ó¬O7/30

¦ý¬O¥L«oÅã¥Ü8/30

TOP

¦^´_ 2# av8d

DateSerial¨ç¼Æ¥²¶·«ü©ú¦~¡B¤ë¡B¤é¯Ê¤@¤£¥i
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 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

¦^´_ 4# GBKEE


    ¬O§_¥i¥H¥uÅã¥Ü¤ë©M¤é´N¦n~
8/1 -2  Åã¥Ü  7/30

TOP

[a1] = "8/1"
[b1] = [a1] - 2

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD