¦b·í¦~·í¤ë¤§«e©Î¬Oµ¥©ó·í¦~·í¤ë¬A´N¦bBÄæ¼Ð¥Ü¤w¨ì´Á¡A¦P®É¡A¦bAÄæ¼Ð¶À¦â
- ©«¤l
- 1363
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1373
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-4-26
|
=IF(("R"&MID(A2,FIND("~",A2)+1,99))-EOMONTH(TODAY(),0)<=0,"¤w¨ì´Á","") |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 1363
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1373
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-4-26
|
¦^´_ 4# p212
RIGHT(A2,9)-->¯ÊÂI ¦p ~107/6/6 §ì¿ù ¤¬¬Û¬ã¨s |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|