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

[µo°Ý] ¤U¦¸¥X³f¤é´£¿ô

[µo°Ý] ¤U¦¸¥X³f¤é´£¿ô

½Ð±Ð¤j¤j,
excelÀÉ®×B2=today()
¦³®a«È¤á²{¦b©T©w¨C¶g¤@¡B¤T¤~¥X³f

¨Ò¦p¡G¤µ¤Ñ¬O12/2,¤U¦^¬O12/4¥X³f
·í12/4¹L«á,¤U¦^¥X³f¬O12/9
­n¦p¦ó¥Î¨ç¼Æ¦Û°Ê´£¿ô¤U¦¸ªº¥X³f¤é´Á?
20191202.223025.jpg

¦^´_ 1# PJChen

B3=IF(RIGHT(TEXT(B1,"[$-404]aaa;@"))="¤@",B1+2,IF(RIGHT(TEXT(B1,"[$-404]aaa;@"))="¤T",B1+5,""))

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 3# hcm19522

³o2­Ó¤½¦¡³£²Å¦X§Úªº»Ý¨D,¥i§_À°¦£¸Ñ»¡¤@¤U?
¥t¥~ §Ú·Q¦bÀx¦s®æÅã¥Ü¨C­Ó¬P´Á¥|ªº¤é´Á
¨Ò¦p¡G¤µ¤Ñ¬O12/3,«hÅã¥Ü±N­n¨ì¨Óªº¶g¥|¤é´Á12/5
«Ý12/5¹L«á,«hÅã¥Ü¤U¤@­Ó¶g¥|¤é´Á12/12
³o¸Ó«ç»ò¤U¤½¦¡?

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 5# hcm19522
·P®¦...

TOP

¦^´_ 3# hcm19522
½Ð°Ý ¤è¦¡ 2=MID(2154321,MOD(B2-2,7)+1,1)+B2
2154321¥Nªí¤°»ò?

TOP

¦^´_ 7# PJChen

©P1®t©P3-->2¤Ñ
©P2®t©P3-->1¤Ñ
©P3®t¤U©P1-->5¤Ñ
.......
©P¤é®t©P1-->1¤Ñ
¤@©P§Î¦¨2154321
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 8# hcm19522
·PÁÂ...

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD