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

[µo°Ý] Åã¥Ü¤µ¤Ñ

[µo°Ý] Åã¥Ü¤µ¤Ñ

¥»©«³Ì«á¥Ñ chiahuo ©ó 2010-6-18 17:15 ½s¿è

¦U¦ì¤j¤j
½Ð°Ý¤@¤U¡A­n¦p¦ó³]­p¡AÅã¥Ü¤µ¤Ñ¬O¤µ¦~²Ä´X¤Ñ©O¡H

=TODAY()-DATE(YEAR(TODAY()),1,1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦pªG1/1¬O¤µ¦~ªº²Ä¤@¤Ñªº¸Ü
¤W­±¤½¦¡+1
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦pªG1/1¬O¤µ¦~ªº²Ä¤@¤Ñªº¸Ü
¤W­±¤½¦¡+1
gong µoªí©ó 2010-6-18 18:06



=TODAY()-DATE(YEAR(TODAY()),1,)
³o¼Ë´N¤£¥Î +1 ¤F
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

ÁÂÁ¨â¦ì¤j¤jªº¸Ñµª

TOP

¨º¦A½Ð°Ý¤j¤j¡A¤p§Ì·Q»¡¥i¥H§âµ{¦¡ªº«e«á¥[¦r¶Ü¡H
¹³     ¤µ¤Ñ¬O¤µ¦~²Ä173¤Ñ
¦b¦P¤@­ÓÀx¦s®æ¸Ì¡C

TOP

¦^´_ 7# chiahuo


="¤µ¤Ñ¬O¤µ¦~²Ä"&TODAY()-DATE(YEAR(TODAY()),1,1)&"¤Ñ"
¤£¹L³o¼Ë±o¨ìªº¬O¤å¦r¤£¯à­pºâ
¦pªG­n«O«ù¼Æ­È¤º®e¥Î¦Û­q®æ¦¡
"¤µ¤Ñ¬O¤µ¦~²Ä"0"¤Ñ"
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ¤j¤j¡A¤p§Ì¨Ã¨S¦³·Q­n°µ­pºâ
¤p§Ì­ì¥»¬O§â"¤µ¤Ñ¬O¤µ¦~²Ä"¦b²Ä¤@­ÓÀx¦s®æ¡Aµ{¦¡¦b²Ä¤G­Ó¡B"¤Ñ"¬O¦b²Ä¤T­Ó
¦³¤j¤jªº±Ð¾É¡A¥H«áÃþ¦ü³oºØªº¤p§Ìª¾¹D­n¦p¦ó³B²z¤F¡AÁÂÁ¡C

TOP

¥Îdatedif³£¥i¥H¡C
½Ð¸Õ¸Õ¬Ý¡C¦p®ÄªG¥¼¦p²z·Q¡A½Ð¤Å¨£¯º¡I
=datedif("1/1/20101",today(),"d")
¦ý¥²¶·¯d·N¤é´Á¶¡¹jªº²Å¸¹¡A¥²¶·»P¹q¸£³]©wªº¬Û¦P¡I
§Ú¤D·s¤B¤@¦W¡A­Y¦³¿ù¡A½Ð¦h¥]®e¡I

TOP

¥»©«³Ì«á¥Ñ chiahuo ©ó 2010-6-29 11:42 ½s¿è
¥Îdatedif³£¥i¥H¡C
½Ð¸Õ¸Õ¬Ý¡C¦p®ÄªG¥¼¦p²z·Q¡A½Ð¤Å¨£¯º¡I
=datedif("1/1/20101",today(),"d")
¦ý¥²¶·¯d ...
trainee µoªí©ó 2010-6-28 12:27


¤j¤j¡G
³o¼Ë¤l¡A¬O¤£¬O¨C¦~³£­n§ó·s¶}©l¤é´Á©O¡H
ÁÙ¦³¤Ñ¼Æ¤Ö¤@¤Ñ®@
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD