两个日期相差 (9168)

D3=TEXT(SUM(DATEDIF(B3,C3,{"y","ym"})*10^{2,0}),"0年00月")&DAY(EOMONTH(C3,-1))*(DAY(C3)<DAY(B3))+DAY(C3)-DAY(B3)&"天"

(迄當月的日> 起當月的日  可)=TEXT(SUM(DATEDIF(B3,C3,{"y","ym","md"})*10^{4,2,0}),"0年00月00天")