计算多个标准的天数差异

本文介绍了计算多个标准的天数差异的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

我想知道如何根据今天的日期计算天数差异.我想创建一个如下所示的表:

Hi I was wondering how I can calculate the number of days difference based on todays date. I would like to create a table like the following:

    >50 >40 >30
Agent A
Agent B

基于此数据:

Agent | Work Completed
A | 12/07/2017
B | 01/03/2017
A | 12/06/2017

结果应该是:

         >50  >40  >30
Agent A  0    1    0
Agent B  1    0    0

我尝试了 sumif 和 sumproduct，但是因为我有一个带有今天日期的字段 (=today())，然后我减去了 2，这不起作用.

I have tried a sumif and sumproduct but as I have a field with todays date (=today()) and then I am minusing the 2, this doesn't work.

非常感谢您的建议.