起止日結合 判斷顯示方式 (14770)

C2=TEXT(A2,"YYY年m月d日")&TEXT(B2,IF(A2=B2,"",IF(TEXT(A2,"E-m")=TEXT(B2,"E-m"),"-d日",IF(YEAR(A2)=YEAR(B2),"-m月d日","-YYY年m月d日"))))