德乐旅行社 发表于 2021-11-26 22:28:00

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


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

经到扯 发表于 2021-12-13 11:31:54

=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")&"天"))),"")

修真悟道 发表于 2022-1-12 06:57:48

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))&"天")),"")

依然猶存 发表于 2022-3-2 15:03:28

感谢两位，我进一步研究学习，谢谢！！！
页: [1]
查看完整版本: 求筛选生日计算的公式，谢谢！