ªð¦^¦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
2019-12-2 22:31

¦^´_ 1# PJChen

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

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD