excel特定时间段如何计算提取天数、月数?答:excel =IF(AND(B2>=DATE(2023,10,1),A2<=DATE(2024,3,31)),DATEDIF(MAX(A2,DATE(2023,10,1)), MIN(B2,DATE(2024,3,31)), "m"),IF(A2<=B2, DATEDIF(MAX(A2,DATE(2023,10,1)), DATE(2023,10,31), "m"), 0)+ IF(B2>=DATE(2024,3,1), DATEDIF(DATE(2024,3,1), MI...
excel如何通过某数据(日期)提取对应数据?答:=VLOOKUP(I$1&G3,IF({1,0},B2:B100&C2:C100,D2:D100),2,0)=VLOOKUP(I$1&G3,IF({1,0},B2:B100&C2:C100,E2:E100),2,0)