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

¨Ï¥Î TODAY() ¨ú±o¨t²Î¤é´Á µM«á©T©w¤£ÅÜ «ç¼Ò°µ©O

¨Ï¥Î TODAY() ¨ú±o¨t²Î¤é´Á µM«á©T©w¤£ÅÜ «ç¼Ò°µ©O

¥»©«³Ì«á¥Ñ mycmyc ©ó 2010-10-13 23:32 ½s¿è

¨Ï¥Î TODAY() ¨ú±o¨t²Î¤é´Á  µM«á©T©w¤£ÅÜ «ç¼Ò°µ©O
¤£µM ¤£ºÞ¨º¤Ñ¶ñ¼g¤é´Á  ¦hÅܤµ¤Ñ¤F

A4¼g  =IF(A4="",TEXT(TODAY(),A4))  Åܦ¨1900/1/0
«ç»ò¿ì  ½Ð±Ð  ÁÂÁÂ

¦p
cell a1 b1 ­ì¨Ó¬OªÅªº
a1 ¥[¤W¸ê®Æ«á b1 ·|¦Û°Ê¸õ¥X¤µ¤Ñ¤é´Á(today())
§Æ±æ«O¯d·í¤Ñ¤é´Á
¤U¦¸¶}±Ò«áµL¶·¸õ¨ì·sªº·í¤é
HI

¤£½×®æ¦¡«ç»ò³]³£·|¬O TODAY() ¡A¥Ã»·¤@ª½§ó·s¡C
§Úı±o­n¥t¥~¼W³]¤@­ÓCell°µ¤H¤uªºtrigger(¹w³]­È¬°False¡A¤£Åª¨ú TODAY() )¡AÂÇ¥¦¨Ó§PÂ_¬O§_Cell:A4­n¨Ï¥Î TODAY() ¨ú±o¨t²Î¤é´Á¡A¤~¯à©T©w¤£ÅÜ¡C
«Ü©êºp¡A§Ú¬O¤p¾Ç¥Í¡A¤£¯à¤U¸üÀɮסA¬O­Ó¤p§¾«Ä¡I

TOP

¦^´_  ANGELA


    §Úªº¨ç¼Æ¤]¨S¿ù¡A¥u¬O¤é´Á¤£¯à©T©w¡A¦ý¬O¤j¤j¼gªº´N¯à©T©w
=IF(A1="","",IF(B1="" ...
newlink µoªí©ó 2014-2-25 20:51

·N«äÀ³¸Ó¬O
¦pªGA1ªÅ¥Õ´N¬OªÅ¥Õ¡A¤£¬O´N  (¦pªGB1¬OªÅ¥Õ´N¦Û°Ê±a¥X¤µ¤Ñ¤é´Á¡A¤£¬OªÅ¥Õ´N«O¯dB1­ì¥»ªº­È)

TOP

¦^´_ 46# newlink


    ÁÙ¦³Ãþ¦üªº¨Ò¤l¥i¥H°Ñ¦Ò¶Ü¡H
À°§U²z¸Ñ¡CÁÂÁÂ
robin

TOP

¦^´_ 45# ANGELA


    §Úªº¨ç¼Æ¤]¨S¿ù¡A¥u¬O¤é´Á¤£¯à©T©w¡A¦ý¬O¤j¤j¼gªº´N¯à©T©w
=IF(A1="","",IF(B1="",TEXT(TODAY(),"YYYY/mm/dd"),B1))
¥J²Ó¬Ý¤j¤jªº¸ÑÄÀ¡AÁÙ¬O¤£¯à²z¸Ñ¡A½¦¨¤å¦r¡G
¦pªGA1ªÅ¥Õ´N¬OªÅ¥Õ¡A¤£¬O´N  (¦pªGB1¬OªÅ¥Õ´N¥´¤W¤é´Á¡A¤£¬O´N«O«ùªÅ¥Õ)
¸£µ¬Âण¹L¨Ó¡A¤j¤j¯à§_¦A¸ÑÄÀ¤@¤U
robin

TOP

¦^´_ 44# newlink


    =IF(A11="","",TEXT(TODAY(),"YYYY/MM/DD"))

  =IF(A1="","",IF(B1="",TEXT(TODAY(),"YYYY/mm/dd"),B1))
  ®t¦b²Ä¤G­ÓIF§PÂ_¡C¦pªGB1ªÅ¥Õµ¹·í¤Ñªº¤é´Á,B1¤£¬OªÅ¥Õ§Yµ¹B1­ì¨Óªº­È(¤ÏÂйBºâ»Ý±Ò°Ê)

TOP

¦^´_ 10# ANGELA


    §Ú¥¿¦n¦³³o¼Ëªº°ÝÃD
§Úªº²z¸Ñ¬O=IF(A11="","",TEXT(TODAY(),"YYYY/MM/DD"))¡A
¥i¬O¤é´ÁÁÙ¬O·|ÀH¨t²Î¦ÓÅÜ

¤j¤j¼gªº´N¤£·|¡A¯à§_§iª¾¬°¤°»ò¶Ü¡H§Ú¸Ó¦p¦ó¸Ñ²z¡H
robin

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-4-7 12:33 ½s¿è

¦^´_ 42# 97forum


    »Ý±Ò¥Î¤ÏÂйBºâ,ª½±µ­×§ïAÄæ¨Ã¤£·|¼v响,¦ý§R°£«á¦A¼g¤J´N·|.¥Î ctrl+; ¤~¸UµL¤@¥¢.

TOP

=IF(A1="","",IF(B1="",TEXT(TODAY(),"YYYY/mm/dd"),B1))
ANGELA µoªí©ó 2010-10-14 14:27

³o­Ó¤½¦¡ÁÙ¬O¤£¦æ¡A¦]¬°¥u­n§ï¹L¤§«á©Ò¦³ªº¤é´Á³£ÁÙ¬O·|Åܦ¨¤µ¤éªº¤é´Á¡C

TOP

Today()«á¦A½Æ»s¡AµM«á¿ï¾Ü©Ê¶K¤W­È¡C

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD