截止日期
帮忙设置下实住天数的函数
77731313124242431313113131323232321212124242418181818181831313131
g5=MIN(IF(D5,D5,C$2)-MAX(B5:C5),DA
h5=IF(B5,IF(D5,D5,C$2)-
5),DAY(IF(D5,D5,C$2)))
C$2)-MAX(B5:C5,EDATE(C$2,-1)),)
i5=IF(D5,D5,C$2)-MAX(IF(C5,C5,EDATE(C$2,-1)),B5)