Question

公式为什么出现#VALUE!没有显示假值？

=IF(DATE(AG2,AK3,AL3)>DATE(AG2,AP3,AQ3),"休假与上班日期不对",IF(OR(AK3<>"",AP3<>"",AL3<>"",AQ3<>""),IF(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))>=DATE(AG2,AK3,AL3),"开始休"&DATE(AG2,AP3,AQ3)-DATE(AG2,AK3,AL3)&"日假至","还有"&DATE(AG2,AK3,AL3)-DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))&"天"&IF(DATE(AG2,AP3,AQ3)=DATE(AG2,AK3,AL3),"","休"&DATE(AG2,AP3,AQ3)-DATE(AG2,AK3,AL3))&"日至"),MONTH(TODAY())&"月份休假日期还没定"))为什么我AK3,AL3有公式的,AP3,AQ3没有公式的只是单元格格式自定义为G/通用格式"日"，删了AP3,AQ3没有显示某月份休假日期还没定