excel怎样用条件格式自动填充合同到期日期答:假定表头占两行,在N3单元格输入公式:=IF(TODAY()>=DATE(K3,L3+H3-3,M3),YEAR(DATE(K3,L3+H3,M3-1)),"")O3 单元格公式:=IF(TODAY()>=DATE(K3,L3+H3-3,M3),MONTH(DATE(K3,L3+H3,M3-1)),"")P3 单元格公式:=IF(TODAY()>=DATE(K3,L3+H3-3,M3),DAY(DATE(K3,L3+...
【急!】excel 表格 日起计算 到期提醒 问题答:在W4单元格输入函数:=IF(LEFT($W4,1)="无","无固定期",DATE(YEAR($V4)+LEFT($W4,1),MONTH($V4),DAY($V4)))在X4单元格输入函数:=IF($X4="无固定期","未到期",IF($X4-TODAY()>30,"未到期",IF($X4-TODAY()<=0,"该合同已过期","即将到期")))在判断是否到期的W4单元格函数...