¦b·í¦~·í¤ë¤§«e©Î¬Oµ¥©ó·í¦~·í¤ë¬A´N¦bBÄæ¼Ð¥Ü¤w¨ì´Á¡A¦P®É¡A¦bAÄæ¼Ð¶À¦â
- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¥»©«³Ì«á¥Ñ p212 ©ó 2018-6-28 14:39 ½s¿è
¦^´_ 1# leiru
1.Àx¦s®æB2¿é¤J
=IF(DATE(MID(A2,FIND("~",A2)+1,3)+1911,MID(A2,FIND("~",A2)+5,2),RIGHT(A2,2))-EOMONTH(TODAY(),0)>0,"","¤w¹L´Á")
¦V¤U½Æ»s
2.®M¥Î¨ì=$A:$A
³]©w®æ¦¡¤Æ±ø¥ó-¨Ï¥Î¤½¦¡¨Ó¨M©wn®æ¦¡¤Æþ¨ÇÀx¦s®æ-¿é¤J
=$B1="¤w¹L´Á"
½Ð°Ñ¦Ò |
-
-
°Ñ¦Ò.zip
(7.71 KB)
|
|
|
|
|
|
- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¥»©«³Ì«á¥Ñ p212 ©ó 2018-6-28 15:35 ½s¿è
¦^´_ 3# hcm19522
·PÁ«ü¾É
¦b¥Á°ê¬ö¤¸¤é´Á®æ¦¡(¦p 107/06/28)¤§«e¥[¤W¡ur¡v©Î¡uR¡v, Excel§Y·|¦Û°ÊÂà´«¦¨¤é´Á (¼Æªº®æ¦¡ 2018/06/28)
(¤â°Ê¿é¤J r107/6/28, r107/06/28, R107/6/28 ©Î R107/06/28 ®ÄªG¥ç¦P)
ps.
2#¤§¤º®e×¥¿: Àx¦s®æB2¿é¤J
=IF((("R"&RIGHT(A2,9))-EOMONTH(TODAY(),0))>0,"","¤w¹L´Á") |
|
|
|
|
|
|