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

[µo°Ý] DATEDIF »P DAY 360 ®t²§

[µo°Ý] DATEDIF »P DAY 360 ®t²§

½Ð°Ý¤@¨ç¼Æ°ÝÃD~
¶}©l®É¶¡¬° 2011/10/5
µ²§ô®É¶¡¬°2015/1/12
§Ú¤À§O¦bC1¤ÎC2¿é¤J¨Ï¥Î
C1=DAYS360(A1,B1)
C2=DATEDIF(A1,B1,"D")

C1=1177
C2=1195
·Q½Ð°Ý³o¨â¤½¦¡ªº®t²§¬°¦ó
¤£¬O³£¬Oºâ¨â¤é´Áªº®t²§¤Ñ¼Æ¶Ü?¬°¦óµª®×¤£¦P?
¦³ª¦¤å»¡Excel ¥u¯à­pºâ30¤Ñ..2¤ë¥÷­pºâ·|¦³°ÝÃD.¦ý¤£¬O«ÜÀ´
¬O§_¦³¤j¤j¯à¦b¨ó§U¸ÑÄÀ¤@¤U
ÁÂÁÂ!!

DAYS360¬O¥H¤@¦~360¤Ñ­pºâ
¹ê»Ú¤@¦~¬O365¤Ñ¡A¨Ï¥Î¦¹¨ç¼Æ­pºâ¨C¦~·|¤Ö5~6¤Ñ

TOP

¦^´_ 2# vvcvc

·PÁÂvvcvcªº¦^ÂÐ
    ©Ò¥H~¤@¯ë¦b¥Î¤é´Á®t²§³£«Øij¥ÎDATEDIF
¦Ó¤£¬ODAY360~§Ú¥i¥H³o»ò¸ÑÄÀ¶Ü?

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-1-14 08:19 ½s¿è

¦^´_ 3# fantersy
DAYS360(start_date,end_date,[method]) ¨ç¼Æ¡A¤@¯ë¥Î©ó¡u·|­p¨t²Î¡v¡A¥H¡u¨C¤ë30¤Ñ¡v¡A¤@¦~12­Ó¤ë¦@¡u360¤Ñ¡v­pºâ¡C
DATEDIF(start_date,end_date,unit)¡A­pºâ¥X¨Óªºµ²ªG¤£¨ü¼í¦~¼vÅT¡C
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 4# p212

·PÁÂp212¤jªº¦^ÂÐ
¸g¤j®a³o»ò¸ÑÄÀ¤j´n¯àÁA¸Ñ³o¨â¤½¦¡ªº®t²§¤F
ÁÂÁ¤j®a!!

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD