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

¨ì´Á¤é¼Ð¦â,¤£³z¹L»²§UÄæ

¨ì´Á¤é¼Ð¦â,¤£³z¹L»²§UÄæ

CÄæ®æ¦¡¤Æ³]©w¥i¥H¤£¥ÎDÄ滲§UÄæ¶Ü?
ª½±µ¦bCÄæ®æ¦¡¤Æ³]©w¤½¦¡´N±NAÄæ¦ÜCÄæ¼Ð¶À¦â

¬¡­¶Ã¯1.zip (54.47 KB)

joyce

¦^´_ 1# leiru

¥u­n±NDÄ檺ÅÞ¿è¸`¨ú¥X¨Ó©ñ¨ì®æ¦¡¤Æªº±ø¥ó¤º§Y¥i¡A
¸Ô½Ð¨£ªþ¥ó~
  1. DATE(MID($C1,FIND("~",$C1)+1,3)+1911,MID($C1,FIND("~",$C1)+5,2),RIGHT($C1,2))-EOMONTH(TODAY(),0)<=0
½Æ»s¥N½X
¬¡­¶Ã¯1.rar (55.13 KB)

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2018-7-28 10:20 ½s¿è

=("R"&RIGHT($C2,9))-EOMONTH(TODAY(),0)<=0

¸ê®Æ¦³¤@«á­±¦³ªÅ¥Õ®æ
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD