若仅判断是不是正确日期如下公式也可以：=IF(A2=0,"",IF(A2-TEXT(DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2)),"yyyymmdd"),"不是正确的日期",TEXT(A2,"0000-00-00"))) 或者=IF(A2=0,"",IF(ISERR(--TEXT(A2,"0000-00-00")),"不正确的日期",TEXT(A2,"0000-00-00")))
