B1单元格的内容必须要每日能够更新,最好用函数公式 =TODAY()
C1单元格写入公式
=IF(--TEXT(A1,"M/D")=B1,"今天生日",IF(--TEXT(A1,"M/D")
或不用B1单元格,C1单元格写入公式
=IF(--TEXT(A1,"M/D")=TODAY(),"今天生日",IF(--TEXT(A1,"M/D")
如何用EXCEL公式计算生日倒计时
A1单元格必须是EXCEL认可的日期格式
B1单元格的内容必须要每日能够更新,最好用函数公式 =TODAY()
C1单元格写入公式
=IF(--TEXT(A1,"M/D")=B1,"今天生日",IF(--TEXT(A1,"M/D")
或不用B1单元格,C1单元格写入公式
=IF(--TEXT(A1,"M/D")=TODAY(),"今天生日",IF(--TEXT(A1,"M/D")
B1单元格的内容必须要每日能够更新,最好用函数公式 =TODAY()
C1单元格写入公式
=IF(--TEXT(A1,"M/D")=B1,"今天生日",IF(--TEXT(A1,"M/D")
或不用B1单元格,C1单元格写入公式
=IF(--TEXT(A1,"M/D")=TODAY(),"今天生日",IF(--TEXT(A1,"M/D")
