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

±Æ§Ç

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-8-24 10:04 ½s¿è

¦^´_ 10# Qin

(¤@)H I³]©w-->TEXT(~,yyy/mm/dd;;)-->¤½¦¡µLªk¸ÑŪ MM/DD/YYYY
(¤G)J3=IF(H3="","",IF($J$1-H3<0,"©|¥¼开©l",IF($J$1-I3>0,"¤wºI¤î","ɬ´f¤¤")))-->¦]¸gTEXT¬O «D¼Æ¦r ­Y§ï¥Î´î ¥i¤Æ¸Ñ
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 11# hcm19522


    ´ú¸Õ¤F. ok

    ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD