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

[µo°Ý] ¤é´Á¿ï¨ú

[µo°Ý] ¤é´Á¿ï¨ú

½Ð°Ý¦U¦ì°ª¤â¡A¤p©f¦³¥H¤UÃøÃD¡A§Æ±æ¯àÀ°¦£¡C
¦p¦ó¦bcolumn("E") ¼g¤Jformula­n¨ú·í¤é«e3¤Ñªº¤é´Á (¤u§@¤é)?

ÁÂÁÂ

¦^´_ 1# waterfox


¬¡°Ê¼s§i:
1.µo°ÝªÌ½Ð¤W¶ÇEXCELÀ£ÁYÀÉ(¤p¾Ç¥Í¤]¥i¥H)
2.°t¦XEXCELÀɽЧâ¥\¯à»¡©ú²M·¡


§A°Ý¹L¤F
http://forum.twbts.com/viewthread.php?tid=6028&highlight=

TOP

¦^´_ 1# waterfox

¥[¸ü¤ÀªR¤u¨ã½c¼W¯q¶°
    E10=WORKDAY(A10,-3,$G$2:$G$20)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

«¢.... §Ñ°O¤F¤w°Ý¹L....ÁÂÁ§A§r register33

ÁÂÁÂHsiehªºÀ°¦£¡A¤w¸Ñ¨M§Úªº°ÝÃD¤F¡A¯uÁÂÁ¡C

TOP

¥»©«³Ì«á¥Ñ sklo ©ó 2012-4-19 13:25 ½s¿è

°¸µMµo²{¼Ó¥D¨º´T¹Ï¡A°²´Á¤@Äæ¡A¡u³Ò°Ê¸`¡v¦b"1-May-12"¡A¤£¬O¦b"1-Apr-12"¡C

TOP

¦^´_ 1# waterfox

À³¸Ó¤]¥i¥H¥Î

=value(A10)-3
¦A³]©w¤é´Á®æ¦¡´N¥i¥H¤F!!
·s¤â¤W¸ô

TOP

¦^´_ 6# cudui

­n¨D¤u§@¤é¤£¬O¤é¾ä¤Ñ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD