求筛选生日计算的公式，谢谢！

林向荣

求.rar (633.06 KB, 下载次数: 10)

2021-11-26 22:28 上传

点击文件名下载附件
求.rar
如左边，能不能选择任一月份，在“提示”栏中，以today为对照，显示三种类型内容：
今年生日已过
今天生日
今年生日还有*天
尝试改了好多次都没改成功。求高手启发一下，谢谢！！！！

蜡笔小丸子

=IFERROR(IF(TEXT(I5,"MM-dd")-TEXT(TODAY(),"MM-dd")=0,"今天生日",IF(TEXT(I5,"MM-dd")-TEXT(TODAY(),"MM-dd")<0,"今年生日已过",IF(TEXT(I5,"MM-dd")-TEXT(TODAY(),"MM-dd")>0,"今年生日还有"&TEXT(I5,"MM-dd")-TEXT(TODAY(),"MM-dd")&"天"))),"")

颜大浹

J5=IFERROR(IF(TODAY()-DATE(YEAR(TODAY()),MONTH(I5),DAY(I5))>0,"今年生日已过",IF(TODAY()-DATE(YEAR(TODAY()),MONTH(I5),DAY(I5))=0,"今天生日","今年生日还有"&-TODAY()+DATE(YEAR(TODAY()),MONTH(I5),DAY(I5))&"天")),"")

素心从简

感谢两位，我进一步研究学习，谢谢！！！