作者:乔山办公网日期:
返回目录:excel表格制作
在B1中输入或zd复制粘贴下列内公式=IF(DATE(YEAR(NOW()),MONTH(A1),DAY(A1))>TODAY(),DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-TODAY(),"生日已容过")
下拉填充
假如计划到时日期在A1单元格,倒计时天数公式为:=N(A1-TODAY())
到时日期也可直接写到公式里:=N("2018/5/1"-TODAY())
设置单元格格式还可加入文字提示:
A1单元格百必须是EXCEL认可的日期格式
B1单元格的内容必须要每日能够度更新,最好用函数公式 =TODAY()
C1单元内格写入公式
=IF(--TEXT(A1,"M/D")=B1,"今天生日",IF(--TEXT(A1,"M/D")<B1,"","还有"&TEXT(A1,"M/D")-B1&"天是生容日"))
或不用B1单元格,C1单元格写入公式
=IF(--TEXT(A1,"M/D")=TODAY(),"今天生日",IF(--TEXT(A1,"M/D")<TODAY(),"","还有"&TEXT(A1,"M/D")-TODAY()&"天是生日"))