Count number of days
=SUM(History[Evaluation])/NUMBER(DATE(TODAY())-DATE(โ1/7/2019โ))
SUM(History[Evaluation])=141 NUMBER(DATE(TODAY())-DATE(โ1/7/2019โ))=0 I want to get โ29โ as counting the days from 1/7/2019 but it keeps giving me โ0โ
How can I get โ29โ?
Subtracting one date from another (e.g., DATE(TODAY())-DATE(โ1/7/2019โ) produces a Duration value, of the form HH:MM:SS (very similar toโbut not!โa Time value). You then need to convert that into a number of days:
NUMBER(HOUR(DATE(TODAY())-DATE(โ1/7/2019โ)) / 24)
That should get you what you need.
Note, too, that you donโt need NUMBER() (the result will already be a number), DATE() around TODAY() (itโs already a date), or DATE() around โ1/7/2019โ (itโll be recognized as a date automatically).
=SUM(History[Evaluation]) / (HOUR(TODAY() - โ1/7/2019โ) / 24)
It works perfectly! I will keep that in mind the number 24!! Thanks!
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |