判斷與今日 五種狀況 (15353)

日期：

C2=IF(YEAR(B2)-YEAR(E$2)=0,TEXT(B2-E$2,"0 !Da!y!s"&";X;TO!DA!Y"),IF(YEAR(B2)-YEAR(E$2)>0,"","XX"))



留言

  1. piny2026年9月22日 下午6:25

    =CHOOSE(SIGN(YEAR(B2)-YEAR(E$2))+SIGN(B2-E$2)+3,"XX","X","TODAY",B2-E$2&" Days","")

    回覆刪除

張貼留言