作者:乔山办公网日期:
返回目录:excel表格制作
假如A1是2017-3-8,则公式可以是
=TEXT(TODAY()-A1,"距离"&TEXT(A1,"e年m月d日")&"已经过去 (0)天了")
在来B1中输入或复制自粘贴下列百公式=IF(DATE(YEAR(NOW()),MONTH(A1),DAY(A1))>TODAY(),DATE(YEAR(NOW()),MONTH(A1),DAY(A1))-TODAY(),"生日度已问过")
下拉填答充
=DATEDIF(TODAY(),DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)),"d")
其中,A1为生日。
设A1为生日.B1输入公式如下:
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))-TODAY()
说明:正数就是还有几天过生日,负数就是已过今年生日几天.