第1个回答 2022-10-21
=IFERROR(DATEDIF(H6,I6,"D"),"")结果为0是DATEDIF函数返回的正常结果(0天到0天之间肯定只有0天),而并非IFERROR函数的除错结果
解决办法:
=if(datedif(h6,i6,"D")>0,datedif(h6,i6,"D"),"")
或者:
=IF(or(h6="",i6=""),"",IFERROR(DATEDIF(H6,I6,"D"),""))
第2个回答 2022-10-22
人工制造一个错误就行了
=IFERROR(DATEDIF(H6,I6,"D")+0/H6/I6,"")