二日期相距 (12352)

C2=SUBSTITUTE(SUBSTITUTE(TEXT(SUM(DATEDIF(A2,B2,{"Y","YM","MD"})*10^{4,2,0})+1,"0年00个月00天"),"年0","年"),"月0","月")

D2=TEXT(SUM(DATEDIF(A2,B2,{"Y","YM","MD"})*10^{4,2,0})+1,"0年00个月00天")



留言