B列记录劳动合同的到期日,希望在C列相邻单元格显示提示:到期日前的30天内显示“即将到期”,并在过期后显示“过期”。C2单元格的函数应怎样写?
=IF(B2<TODAY()+30,"即将到期","过期")
=IF(B2<TODAY()+30,即将到期,过期)
=IF(C2<TODAY(),"过期",IF(C2<=TODAY()+30,"即将到期",""))
=IF(C2>TODAY(),IF(C2>TODAY()+30,"","即将到期"),"过期")