[Excel] 日期轉檔技巧

西元日期轉中文日期
=TEXT($E2,"r")&"年"&TEXT($E2,"mm")&"月"&TEXT($E2,"dd")&"日"

判斷日期大小
=IF(E2>DATEVALUE("2000/9/2"),"A","B")