问题:计算两日期差,没到期显示“剩余n天”,超过显示“超出n天”
解决方法:If函数或者Text函数
=IF(B2<A2,"剩余","超出")&ABS(B2-A2)&"天"
=TEXT(B2-A2,"超出0天;剩余0天;超出0天")