=IF(AND(A1>=TODAY(),A1<=TODAY()+7),你要显示的数据,"")
=AND(A1>=TODAY(),A1<=TODAY()+7)或=(A1>=TODAY())*(A1<=TODAY()+7)
=IF(AND(Q2>=TODAY(),Q2<=TODAY()+7),“mail”,"")
