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

­pºâ°h¥ð®É¶¡

­pºâ°h¥ð®É¶¡

°h¥ð®É¶¡ªí.rar (7.07 KB) ½Ð°Ý¦p¦ó¥Î¤½¦¡­pºâ¶ZÂ÷°h¥ðÁÙ¦³¦h¤Ö®É¶¡(¦~¼Æ,¤ë¼Æ,¤é¼Æ)

¥»©«³Ì«á¥Ñ jackdream ©ó 2010-10-27 11:57 ½s¿è

¦^´_ 1# mmggmm

°Ñ¦Ò¬Ý¬Ý~
http://www.excelpx.com/dispbbs.a ... D=143830&Page=1

TOP

¥X¥Í¤é´Á¨ì¤µ¤Ñ¬O¦~ÄÖ,¤µ¤Ñ¨ì°h¥ð¤é´Á´N¬O¶ZÂ÷°h¥ð®É¶¡,¤èªk¤@¼Ë

TOP

=DATEDIF(TODAY,EDATE(A2,°h¥ð¦~ÄÖ*12)+1,"y")&"Yrs,"&DATEDIF(TODAY,EDATE(A2,°h¥ð¦~ÄÖ*12)+1,"ym")&"Mths and "&DATEDIF(TODAY,EDATE(A2,°h¥ð¦~ÄÖ*12)+1,"md")&"Days"
¤w¥i¥H¸Ñ¨M¦ý¦pªG°h¥ð¦~ÄÖ³]¬°60¦ý¤µ¦~¤w61·³©Ò±oµ²ªG=#NUM!½Ð°Ý¦p¦ó¸Ñ¨M

TOP

¦^´_ 4# mmggmm


    =if(¦~ÄÖ>°h¥ð¦~ÄÖ,"",­ì¤½¦¡)

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD