excel如何计算两组日期之间相交的天数?答:在F3和G3中分别输入或复制粘贴下列公式 =MIN(C3,E3)-MAX(B3,D3)+1 =IF(MIN(C3,E3)-MAX(B3,D3)+1<=0,"无相交日期","相交日期"&TEXT(MAX(B3,D3),"YYYYMMDD")&"-"&TEXT(MIN(C3,E3),"YYYYMMDD")&"共"&MIN(C3,E3)-MAX(B3,D3)+1&"天")选择F3:G3,下拉填充 ...
EXCEL如何跨年统计一个日期段内每月的天数答:c5公式参考:=IF(DATE(2014+INT(ROW(A13)/12),MOD(ROW(A13),12)+1,1)<$C$2,"",IF(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1)>$C$3,"",IF(DATE(2014+INT(ROW(A12)/12),MOD(ROW(A12),12)+1,1)=DATE(YEAR($C$2),MONTH($C$2),1),NETWORKDAYS(DATE(2014+...