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

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

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

¦^´_ 9# trainee


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



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

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

¦^´_ 12# PD961A


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

TOP

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

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD