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

[µo°Ý] ­û¤u¯S¥ð­pºâ

¦^´_ 22# softsadwind


    ¦pªG­nÅçÃÒ¤µ¦~©³ªº¯S¥ð
E2=IF(D2="","",(DATE(2012,12,31)-D2)/365)

³o¤@¬q¿ù»~ §Ñ¤F¤w¸g2013¤F
E2=IF(D2="","",(DATE(2013,12,31)-D2)/365)
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

ÁÂÁ¡A¾Ç²ß¨ì¤£¤Ö
mandy

TOP

¤£¦n·N«ä~~ª©¥D!!§Ú­è¥[¤J³o°Q½×°Ï,¦]¦³»Ý­n³o­Ó½d¨Ò¡A½Ð°Ý¥i¥H±Hµ¹§Ú¶Ü?ÁÂÁ [email protected]

TOP

¦^´_ 3# Eugene


    ¥i§_´£¨Ñc2ªº¤½¦¡¡AÁÂÁÂ~~

TOP

¦^´_ 24# sm1047

C2=IF(B2="","",IF(I2>0,(I2-B2)/365,(NOW()-B2)/365))

TOP

ª©¥D±z¦n~

¤£¦n·N«ä
§Ú­è¥[¤J³o°Q½×°Ï,¦]¤u§@»Ý¨D¡A¤è«K¥ý´£¨ÑÀ£ÁYÀɵ¹§Ú¶Ü? ·PÁÂ
«H½c: [email protected]

TOP

¦^´_ 1# jessicawu


    ¥i¥H®M¥Î¨ì©Ò¦³ªºEXCELª©¥»¶Ü?
=IF(DATEDIF(F2,TODAY()-(H2-G2),"y")<10,LOOKUP(DATEDIF(F2,TODAY()-(H2-G2),"y"),$Q$1:$Q$4,$R$1:$R$4),MIN(30,DATEDIF(F2,TODAY()-(H2-G2),"y")-9+14))
¥t¥~¥i¥H½Ð±Ð¤j¤j³o¼Ë¼g­þ¸Ì¦³¿ù¤F??

TOP

¥¿¦n§ä³oºØ¤u¦¡°Qºâ¡AÁÂÁ¡C

TOP

¦^´_ 1# jessicawu


    ·PÁ¤À¨É¡ã

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD