示例1:
=IFERROR(DATEDIF(TODAY(),DATE(YEAR(L5),MONTH(L5) M5,DAY(L5)),"d"),"")
已到归还日期的,第二参数大于第一参数,会出错。
示例2:
=SUM(DATEDIF(G3,TODAY(),{"md";"ym";"y"})*IF(F3=$K$2,$K$3:$K$5,IF(F3=$L$2,$L$3:$L$5,$M$3:$M$5)))
=SUMIF($F:$F,K2,$H:$H)
示例3:
=IF(DATEDIF(J20,TODAY() 6,"yd")<7,"√","")
,