Hello, The number of days between dates I am referring to is as follows: The following table records the date when a user opens a Word document in this case.
I would need to add a column indicating the days the "Word" application was used. For example, with the filter of dates from 09/01/2020 to 09/30/2020, in that month the user only has documents open on 3, 5 and 28, in this case in the third column it must indicate 3 days.
I've been thinking over and over again and I haven't been able to know where to start, I hope you can give me some idea.
Hello @pranit828 , The apologies for not giving me to understand, I will try to be more precise: The following image shows how the data is approximately.
in this other image is the result, which tells us that AMENCISOV got to use the software "Word" in three days (10, 11 and 14) and "APACHASP" only one day (21). I think that the result should be given in a new table "CALCULATETABLE" and that as a calculated column I don't see that it is possible.