计算多个标准的天数差异 [英] calculate number of days difference with multiple criteria

问题描述

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

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.

非常感谢您的建议.

推荐答案

这里有一个 论坛

这篇关于计算多个标准的天数差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！