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

[µo°Ý] ½Ð°Ý¼Ï¯Ã¤ÀªRªí¥i¥H°µ¤é´Áªº´îªk¶Ü

[µo°Ý] ½Ð°Ý¼Ï¯Ã¤ÀªRªí¥i¥H°µ¤é´Áªº´îªk¶Ü

½Ð°Ý¤@¤U¡A¤p§Ì­è½ñ¤JEXCEL³o¥@¬É¡A¦³«Ü¦h¤£À´ªº¦a¤è

§Ú±N¤@¥÷ªí®æ¥Î¼Ï¯Ã¤ÀªRªí¦C¥X§Ú­nªº®æ¦¡

¨Ò¦p:
¬~¦çªA
2012/01/01
¬~³Q³æ
2012/01/02

¦³¿ìªk¦b¤é´Áªº«á­±¦h¥X¤@­ÓÄæ¦ì¡A²Î­p¥X¬Û®t¤µ¤Ñ¦³´X¤Ñ¶Ü?
¦pªG¼Ï¯Ã¤ÀªRªíµLªk°µ¨ì¡A¦³¨ä¥L¤èªk¥i¥H°µ¨ì¶Ü?

¦^´_ 8# register313

¥i¥H¤F¡A ÁÂÁÂÀ°¦£

­ì¨Ó¬O®t¦bISNUMBER ©MISERROR ªº³¡¤À
§Ú¥h½½³o¨â­Ó²[¦¡ªº®t²§©Ê¦b¨ºÃä

¦b¤@¦¸ªº·PÁÂ:D

TOP

¦^´_ 7# warhead

B5=IF(ISERROR(TODAY()-A5),"",TODAY()-A5)

TOP

¦^´_ 6# register313


days.rar (63.77 KB)

ªþ¤WÀÉ®×

TOP

¦^´_ 5# warhead

¥i§_¤W¶ÇÀÉ®× ¥H«K¤F¸Ñ§Aªº¼Ï¯Ã¤ÀªRªí¤Î¬°¦ó¤½¦¡§ì¤£¨ìAÄæ
¤å¦r(¾÷±Kªº³¡¥÷)¥iÀH«K§ï

TOP

¦^´_ 4# register313


¥ªÃä¬O¼Ï¯Ã¤ÀªRªí¡A³o¤½¦¡¦n¹³µLªkŪ¨ú¨ìAªºÄæ¦ì

TOP

¦^´_ 3# warhead

B6=IF(ISNUMBER(A6),TODAY()-A6,"")

TOP

¦^´_ 2# dino1978

ÁÂÁ±zªº¦^µª¡A¥i¯à¬O§Úªí¹Fªº¤£²M·¡¡A
§Ú±N¹Ï¶K¤W¨Ó¡A¤º®e¬O¤½¥qªº¸ê®Æ¡A©Ò¥H¥Î¦Ç¦â¾×°_¨Ó¡A



¦b¤é´Á«á­±¡A¥DºÞ¬O§Æ±æ¬Ý¨ì¶ZÂ÷¤µ¤Ñ¬O¦³¦h¤Ö¤Ñªº®t¶Z¡A
¥Î¼Ï¯Ãªº¤è¦¡¦n¹³¤£¯à§â¤é´Áª½±µ´î±¼today()¡A
¸ê®Æ·|¤@ª½ÅÜ°Ê¡A©Ò¥H¦n¹³¤]¨S¿ìªkª½±µ¥Î©Ô®æ¦¡ªº¤è¦¡¤@¦¸©Ô§¹¡A
©Î¬O¦³¨ä¥Lªº¦n«Øij¶Ü¡H

TOP

¦^´_ 1# warhead
   ¤£ª¾¹D¬O¤£¬O§A­nªºµ²ªG

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD