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

¨Ì³W«h±a¥X¥¿½T¤é´Á

¨Ì³W«h±a¥X¥¿½T¤é´Á

°ÝÃD1. ¨DEÄ浪®×
EÄæ¥æ©ö¦¨¥\©Î¥æ©ö¥¢±Ñ¬O¡GDÄæ¨ê¥d¤é¬O¬ÝBÄæ¥æ©ö¤é+2¤Ñ
¨Ò¦p:
±¡ªp¤@¡G¥æ©ö¤é20210705 / ¨ê¥dºI¤î¤é202107072325959¡A«È¤á¨ê¥d¤é20210705104123¡A¦³¦bºI¤î¤é¤º¡A©Ò¥HE2Åã¥Ü¡G¥æ©ö¦¨¥\
±¡ªp¤T¡G¥æ©ö¤é20210705 / ¨ê¥dºI¤î¤é202107072325959¡A«È¤á¨ê¥d¤é20210708053652¡A¨S¦³¦bºI¤î¤é¤º¡A©Ò¥HE2Åã¥Ü¡G¥æ©ö¥¢±Ñ¡A¤@¥¹Åã¥Ü¥¢±Ñ¡AFÄæ¦ÜIÄæµL»ÝÅã¥Ü
°ÝÃD2. ¨DFÄ浪®×
­YDÄæ¨ê¥d¤é¦b¤W¤È¡A«h½Ð´Ú¤é¡×¨ê¥d¤é(¨Ò¦pD2=20210705104123¡A¨ê¥d¤é20210705 / ®É¶¡104123¤]´N¬O¦­¤W10ÂI41¤À23¬í)
­YDÄæ¨ê¥d¤é¦b¤U¤È¡A«h½Ð´Ú¤é¡×¨ê¥d¤é¡Ï1¤é(¨Ò¦pD3=20210705195526¡A¨ê¥d¤é20210705 / ®É¶¡195526¤]´N¬O±ß¤W7ÂI55¤À26¬í)
°ÝÃD3. ¨DGÄ浪®×
¤J±b¤é=FÄæ½Ð´Ú¤é+1¤u§@¤é(¤]´N¬O¶g¤»¤Î¶g¤é¤Î°ê©w°²¤é¤£ºâ)
°ÝÃD4. ¨DHÄ浪®×
³øªí¤é=GÄæ¤J±b¤é+¤U¤È4ÂI(³o¬O©T©w®É¶¡)
°ÝÃD5. ¨DIÄ浪®×
¤W¶Ç¤é=CÄæ¨ü²z¤é+4¤u§@¤é(¤]´N¬O¶g¤»¤Î¶g¤é¤Î°ê©w°²¤é¤£ºâ)+¦­¤W10ÂI(³o¬O©T©w®É¶¡)

¨Ì³W«h±a¥X¥¿½T¤é´Á.zip (7.89 KB)

joyce

1) E2//
=IF(OR(B2="",D2=""),"","¥æ©ö"&IF(LEFT(D2,8)-B2<=2,"¦¨¥\","¥¢±Ñ"))

2) F2//
=IF(E2<>"¥æ©ö¦¨¥\","",--TEXT(TEXT(D2,"0-00-00 00\:00\:00")+0.5,"yyyymmdd"))

¨ä¥¦²o¯A¤u§@¤é°ÝÃD, ¥Îworkday¤]¤£ºë·Ç,
¦]¦³³sÄò°²¤é, ¤Î©P¤»½Õ¾ã¸É¯Z¤é, »Ý­n¥ý°µ¹ï·Óªí¤~¥i¥H~~

TOP

¦^´_ 2# ­ã´£³¡ªL


    ÁÂÁ¤j®v¦^ÂÐ,
½Ð°Ý¤j®v:
¥u­n¦C¥X°ê©w°²¤é¤Î©P¤»½Õ¾ã¸É¯Z¤é¶Ü???©Î¬O¨C¶g¤»¤Î¨C¶g¤é¥ð®§¤é¤]­n¦C¥X??
     °ê©w°²¤é                       ¸É¯Z¤é
20210918(¤»)        20210911(¤»)
20210919(¤é)       
20210920(¤@)       
20210921(¤G)       
20211009(¤»)       
20211010(¤é)       
20211011(¤@)       
20211231(¤­)       
20220101(¤»)       
20220102(¤é)
joyce

TOP

¦^´_ 3# leiru

¸`¤é¤u§@ªí¬OÀH«K¿é¤Jªº¤é´Á, ¦Û¦æ¥h¿é¤J¥¿½Tªº:
Xl0000667.rar (8.06 KB)

TOP

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