帮莪解释一下这个excel生日提醒公式吧~=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))=TODAY(),"今天",""&DATE(IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))>=TODAY(),YEAR(TODAY()),YEAR(TODAY())+1),MONTH(B2),DAY(B2))-TODAY()&"天")解释一下什么
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 11:08:43
![帮莪解释一下这个excel生日提醒公式吧~=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))=TODAY(),](/uploads/image/z/5480207-71-7.jpg?t=%E5%B8%AE%E8%8E%AA%E8%A7%A3%E9%87%8A%E4%B8%80%E4%B8%8B%E8%BF%99%E4%B8%AAexcel%E7%94%9F%E6%97%A5%E6%8F%90%E9%86%92%E5%85%AC%E5%BC%8F%E5%90%A7%7E%3DIF%28DATE%28YEAR%28TODAY%28%29%29%2CMONTH%28B2%29%2CDAY%28B2%29%29%3DTODAY%28%29%2C%22%E4%BB%8A%E5%A4%A9%22%2C%22%22%26DATE%28IF%28DATE%28YEAR%28TODAY%28%29%29%2CMONTH%28B2%29%2CDAY%28B2%29%29%3E%3DTODAY%28%29%2CYEAR%28TODAY%28%29%29%2CYEAR%28TODAY%28%29%29%2B1%29%2CMONTH%28B2%29%2CDAY%28B2%29%29-TODAY%28%29%26%22%E5%A4%A9%22%29%E8%A7%A3%E9%87%8A%E4%B8%80%E4%B8%8B%E4%BB%80%E4%B9%88)
帮莪解释一下这个excel生日提醒公式吧~=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))=TODAY(),"今天",""&DATE(IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))>=TODAY(),YEAR(TODAY()),YEAR(TODAY())+1),MONTH(B2),DAY(B2))-TODAY()&"天")解释一下什么
帮莪解释一下这个excel生日提醒公式吧~
=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))=TODAY(),"今天",""&DATE(IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))>=TODAY(),YEAR(TODAY()),YEAR(TODAY())+1),MONTH(B2),DAY(B2))-TODAY()&"天")
解释一下什么含义什么的 老师让莪明天去他那里解释给他听
如果有错误 那帮忙修改下
帮莪解释一下这个excel生日提醒公式吧~=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))=TODAY(),"今天",""&DATE(IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))>=TODAY(),YEAR(TODAY()),YEAR(TODAY())+1),MONTH(B2),DAY(B2))-TODAY()&"天")解释一下什么
一个判断式:
如果“今年+B2的月和日”等于今天日期,就显示“今天”;否则,如果大于等于今天日期,就显示“今年+B2的月和日”的日期减掉今天的日期,否则就是“明年+B2的月和日”的日期减掉今天的日期.
后面加上“天”字.
里面的“""&”是多余的,可以省略.