[ 多选题 ] 常识 中 

B列记录劳动合同的到期日，希望在C列相邻单元格显示提示：到期日前的30天内显示“即将到期”，并在过期后显示“过期”。C2单元格的函数应怎样写？
  • A、 
    =IF(B2<TODAY()+30,"即将到期"，"过期")
  • B、 
    =IF(B2<TODAY()+30,即将到期,过期)
  • C、 
    =IF(C2<TODAY(),"过期",IF(C2<=TODAY()+30,"即将到期",""))
  • D、 
    =IF(C2>TODAY(),IF(C2>TODAY()+30,"","即将到期"),"过期")
查看题目所在试卷