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

[µo°Ý] ¿ï¾Üµ²³t,¨Ã²£¥Í-©T©w¤£Åܪº¤é´Á»P®É¶¡-

[µo°Ý] ¿ï¾Üµ²³t,¨Ã²£¥Í-©T©w¤£Åܪº¤é´Á»P®É¶¡-

§Úªº»Ý¨D¬O:¿ï¾Ü[µ²§ô],¨Ã·|¥X²{©T©w¤£Åܪº¤é´Á»P®É¶¡
A2Äæ¦ì=>§Ú¨Ï¥Î[¸ê®ÆÅçÃÒ]=>²M³æ=>¨Ó·½:µ²§ô
¨Ã¦bB2Äæ¦ì=>ÂI¿ï[µ²§ô]®É=>´N¶]¥X©T©w¤£Åܪº¤é´Á»P®É¶¡



§Ú¸Õ¹L¥H¤U«ü¥O,¦ý³£¤£¬O§Ú»Ý­nªº
=IF($A2="","",IF(B2="",TEXT(TODAY(),"yyyy/mm/dd"),B2))=>¥u¦³¤é´Á
=IF($A3="","",IF(B3="",B3,TODAY()))=>¥X²{2019/03/19 00:00(¦Ó¥B¤é´ÁÁÙ·|¦Û°Ê§ó·s)
=TEXT(IF(A4="","",IF(B4<>"",NOW(),A4)),"yyyy-mm-dd hh:mm;@")=>¦³¥X²{§Ú­nªº¤é´Á»P®É¶¡,¦ýÁÙ¬O¦Û°Ê§ó·s


¦A³Â·Ð¦Ñ®v­Ì,ÁÂÁÂ

=IF(A1="µ²§ô",IF(OR(B1=0,B1=""),NOW(),B1),"")
§ä¨ì³o­Ó¨ç¼Æ,¬O²Å¦X»Ý¨Dªº,Åý¤j®a°Ñ¦Ò

TOP

A2Äæ¦ì=>§Ú¨Ï¥Î[¸ê®ÆÅçÃÒ]=>²M³æ=>¨Ó·½:¶}©l,³B²z¤¤,µ²§ô
§Ú¿ï¾Ü[µ²§ô]®É,¤~·|Åã¥Üµ²§ôªº®É¶¡

¦pªG¥H¤W¤è¦¡¤£¦æªº¸Ü,¤]¥i¥H,¨C­Ó²M³æ=>¨Ó·½:³£Åã¥Ü®É¶¡¤]¥i¥H,¦ý¤é´Á»P®É¶¡³£­n¬O©T©wªº


§Ú­è­è¸Õ¤F
=IF(ISBLANK(A13),"",IF(B13="",NOW(),B13))
¦ý¥u­nA13¦³­È,´N¥X²{²Ä¤@¦¸­Èªº®É¶¡,´N¤£¯à¦AÅܰʤF

TOP

§Ú­è­è¸Õ¤F¤@­Ó¨ç¼Æ
=IF((C11=1),IF(OR((D11=""),D11=0),NOW(),D11),"")

¦bC11Ä楴¤W1,´N·|ÅV¥Ü"¤£Åܰʪº"¤é´Á»P®É¶¡
§Ú§â=IF((C11=1)
1§ï¦¨"µ²§ô"¤Î¨ç¼ÆFIND=>¬Ò¤£¥i¦æ:'(

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD