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

¨D¸Ñ¤u§@©µ»~¤Ñ¼Æ­pºâ

¨D¸Ñ¤u§@©µ»~¤Ñ¼Æ­pºâ

©µ»~¤Ñ¼Æ­pºâ.rar (8.18 KB)

¦pªþ¥ó, ¶À¦â¼Ð¥Ü³B¨D¸Ñ©µ»~¤Ñ¼Æ­pºâ, ¦]¸ê®Æµ§¼Æ²³¦h§Æ±æ¯à²¤Æ¨ç¼Æ·À¤Ö¹q¸£¸ê®Æ¹Bºâ

¦^´_ 1# 074063


    §ÚµLªk¤U¸ü±zªº¸ê®ÆÀ°±z°µ, ¦ý§Ú°µ¤F¤@¥÷¦hºØ´£¿ô¤è¦¡¨Ñ±z°Ñ¦Ò! ±z¥u­nÂI¤J®æ¤l´N¥i¬Ý¨ì¨ç¼Æ! Book1.rar (10.26 KB)

TOP

¥»©«³Ì«á¥Ñ 074063 ©ó 2015-8-1 22:55 ½s¿è

¦^´_ 2# tomtracy


    ·PÁÂtomtracy¤j¤j¸Ñµª, ÁöµMµ²ªG¤£¬O§Ú·Q­nªº

    §Æ±æ©µ»~¤Ñ¼Æ¬O¥HD:HÄæ¦ì³Ì«á¤@­Ó¦³¸ê®Æªº¤é´Á-¹w©w§¹¦¨¤é´Á

TOP

=IF(C4="","",IF(COUNT(D4),TEXT(LOOKUP(99999,D4:H4)-C4,"0;;0"),TODAY()-C4))

TOP

¦^´_ 4# ANGELA


    º}«G  !¥»¨Ó§Ú·Q¥Î =MAX(H4-C4,0)  µ²ªG¬Ý±zªºµ²ªG§ó¥[§¹¬ü  µ¹§A¤@­ÓÆg
¤T¤d¦~Ū¥v, ¤£¥~¥\¦W§Q¸S, ¤E¸U¨½®©¹D, ²×Âk¸Ö°s¥Ð¶é

TOP

¥»©«³Ì«á¥Ñ 074063 ©ó 2015-8-1 23:31 ½s¿è

¦^´_ 4# ANGELA


    ·PÁÂANGELA¤j¤j¸Ñµª, µ²ªG¥¿¬O·Q­nªº, ½Ð°ÝD4:H4¬°¤£³sÄò¸ê®Æ½d³ò, ¨ç¼Æ¦p¦ó§ï


TOP

=IF(C4="","",IF(COUNT(D4),TEXT(LOOKUP(99999,IF(D4:M4<9999,"",D4:M4))-C4,"0;;0"),TODAY()-C4)) °}¦C¤½¦¡

TOP

¦^´_ 7# ANGELA


    ¤Ó´Î¤F, ¥i¬OE,G,I,KÄæ>=9999ªº¸Ü¦n¹³­È´N·|¤£¹ï¤F

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD