使用Countifs函数在Excel中显示不正确的信息

发布于 2025-02-09 20:25:56 字数 387 浏览 1 评论 0原文

我在Excel中有一个名为“下一个操作日期”的日期，我正在尝试计算和显示从今天起1周内落在1周内的日期数（（）（今天），

我尝试了以下两个列公式

=COUNTIFS(Table22[Next Action Date Due],"<=TODAY()+7",Table22[Next Action Date Due],">=TODAY()")

，并且

=COUNTIFS(Table22[Next Action Date Due],"<=TODAY()+7"&">TODAY()")

都它们中似乎显示错误的数字，而且如果我更改列中的一个日期之一以在范围内，仍然不计算。我想知道我在做什么错。

原文

I have a column in excel with dates named "Next Action Date Due", and I am trying to count and display the number of dates that fall within 1 week from today (TODAY())

I tried both of the following column formulas

=COUNTIFS(Table22[Next Action Date Due],"<=TODAY()+7",Table22[Next Action Date Due],">=TODAY()")

and

=COUNTIFS(Table22[Next Action Date Due],"<=TODAY()+7"&">TODAY()")

both of them seem to display the wrong number and also if I change one of the dates in the column to fall within range it still isn't counted. I'm wondering what I'm doing wrong.

分享到QQ

分享到微博