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

¦X¨ÖÀx¦s®æ®æ¦¡¡A¦bAÄ椺ªº¨´¤é­Y¬O¶W¹L·í¤ë¤ë©³´N¦bBÄæÅã¥Ü¤w¨ì´Á

¦X¨ÖÀx¦s®æ®æ¦¡¡A¦bAÄ椺ªº¨´¤é­Y¬O¶W¹L·í¤ë¤ë©³´N¦bBÄæÅã¥Ü¤w¨ì´Á

°ÝÃD¡G
AÄ椺ªº¨´¤é­Y¬O¶W¹L·í¤ë¤ë©³´N¦bBÄæÅã¥Ü¤w¨ì´Á
¨Ò¦p
¤µ¤Ñ9/7¡AA2Àx¦s®æ¨´¤é¬°109/01/15¡A«hB2¤£Åã¥Ü
¤µ¤Ñ9/7¡AA2Àx¦s®æ¨´¤é¬°107/09/30¡A«hB16Åã¥Ü¤w¨ì´Á

¬¡­¶Ã¯2.zip (7.24 KB)

joyce

¦^´_ 1# leiru

§A­ì¥»ªþ¥óªº¤½¦¡§ï¦¨³o¼Ë©O?
  1. =IF(DATE(MID(A2,FIND("~",A2)+1,3)+1911,MID(A2,FIND("~",A2)+5,2),MID(A2,FIND("~",A2)+8,2))-TODAY()>0,"","¤w¨ì´Á")
½Æ»s¥N½X
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

=IF(("R"&RIGHT(A2,9))-eomonth(NOW(),0)>0,"","¤w¨ì´Á")

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD