我现在有一张表，它查看列"；我"并在列"0"中显示；J"；如果日期是：
"8天后到期">
"7天后到期">
"6天后到期">
"5天后到期">
"4天后到期">
"3天后到期">
"2天后到期">
"明天到期">
"昨天到期">
"今天到期">
"逾期7天">
"逾期14天">
"逾期21天">
"逾期超过30天"；
公式：
=IF(I14=TODAY()+8, "Due in 8 days",
IF(I14=TODAY()+7, "Due in 7 days",
IF(I14=TODAY()+6, "Due in 6 days",
IF(I14=TODAY()+5, "Due in 5 days",
IF(I14=TODAY()+4, "Due in 4 days",
IF(I14=TODAY()+3, "Due in 3 days",
IF(I14=TODAY()+2, "Due in 2 days",
IF(I14=TODAY()+1, "Due Tomorrow",
IF(I14=TODAY()-1, "Due Yesterday",
IF(I14=TODAY(), "Due Today",
IF(I14>TODAY()-7, "Overdue within 7 days",
IF(I14>TODAY()-14, "Overdue 14-17 Days",
IF(I14>TODAY()-21, "Overdue 20-23 days", "Overdue 30-33 days")))))))))))))
问题：我可以用什么公式来查找：
"到期4-7天"；以及"；逾期10-13天"；
在@Matt 的两条评论之后
您需要更改公式。
和@Terry
正确。但我找不到一个类似于"；逾期10-13天"；
你应该遵循这个模式
=IF(AND(I14<TODAY()-14,I14>TODAY()-17), "Overdue 14-17 Days","rest_if_formula")
做试着自己弄清楚(你可以做到(