EXCEL中if函数日期的判断

Question

用IF函数判断，筛选出大于等于今天，小于等于今天加上7天的日期，公式如何编写？

Answer 1

=IF(AND(A1>=TODAY(),A1<=TODAY()+7),你要显示的数据,"")追问

=IF(AND(Q2>=TODAY(),Q2<=TODAY()+7),mail,"")
可是显示的不是mail而是#NAME？
为什么？

追答

应为
=IF(AND(Q2>=TODAY(),Q2<=TODAY()+7),"mail","")

本回答被提问者和网友采纳

Answer 2

=AND(A1>=TODAY(),A1<=TODAY()+7)
或
=(A1>=TODAY())*(A1<=TODAY()+7)

Answer 3

=IF(AND(Q2>=TODAY(),Q2<=TODAY()+7),“mail”,"")