1\=IF(DATEDIF(B9,C9,"y")>0,DATEDIF(B9,C9,"y")&"年","")&IF(AND(DATEDIF(B9,C9,"y")>0,DATEDIF(B9,C9,"ym")>0),"零","")&IF(DATEDIF(B9,C9,"ym")>0,DATEDIF(B9,C9,"ym")&"个月","")&IF(DATEDIF(B9,C9,"md")>0,DATEDIF(B9,C9,"md")&"天","")
2\=TEXT(DATE(LEFT(A8,4),MID(A8,5,2)+1,0)-DATE(LEFT(A8,4),MID(A8,5,2),RIGHT(A8,2)),0)
|
楼主: bynbyn
[复制链接]
IP卡
狗仔卡
发表于 2012-4-29 19:47
显身卡
