|
哈。好奇问一问这是什么级别的EXCEL考试试题了？F4公式下拉：=D4+E4-1G4公式下拉：=IF(TODAY()>=F4,"是","否")H4公式右拉至J4再下拉：=IF((DATEDIF($F4,TODAY(),"D")>=--LEFT(H$3,FIND("-",H$3)-1))*(DATEDIF($F4,TODAY(),"D")<=--MID(SUBSTITUTE(H$3,"天",),FIND("-",H$3)+1,9)),"是","否")K4公式下拉：=IF(DATEDIF($F4... |
