ªð¦^¦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

¤p§Ì°µ¤@¥t¤@­Ó­×§ï¡AÅܦ¨¤µ¦~³Ñ¤U´X¤Ñ
=DATEDIF(TODAY(),DATE(YEAR(TODAY()),12,31),"D")
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

¦^´_ 12# PD961A


¦hÁ´£ÂI¡I·s¤B¤@®É¤j·N¡A¥´¦h咗¤@­Ó"1"¡I

TOP

¦^´_ 10# chiahuo


¦hÁ¤j¤j´£ÂI¡I·s¤B©l²×¥\¤Ò¦³­­¡A¯u¬O¯Zªù§Ë©ò¡I

DATEDIF(DATE(YEAR(TODAY()),1,1),TODAY(),"D")+1

TOP

¦^´_ 9# trainee


   
"1/1/20101" ®æ¦¡¤£¹ï  20101³o¬O18000¦~¤§«áªº®É¶¡
GBKEE µoªí©ó 2010-6-29 19:30



'=DATEDIF("2010/1/1",TODAY(),"d")

TOP

¥Î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

"1/1/20101" ®æ¦¡¤£¹ï  20101³o¬O18000¦~¤§«áªº®É¶¡
    http://share.tpc.edu.tw/_vti_bin/help/1028/sts/html/ldatedif.htm

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

¥Î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

ÁÂÁ¤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

¦^´_ 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

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD