帮莪解释一下这个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/12/25 00:30:45
帮莪解释一下这个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中放生日日期,如果今天是生日,显示今天,否则显示下一下生日距离今天有几天,函数的意思可以自己参照帮助文件,帮你精简一下公式.
=TEXT(DATE(YEAR(B2)+(TEXT(TODAY(),"m-d")-TEXT(B2,"m-d")>0),MONTH(B2),DAY(B2))-TODAY(),"0天;;今天")
zipall老师DATEDIF用法很好,学习.