how to formula? number of days today of the current yr / 365 . example date today is jan 4, 2021 so it should be 4/365
Hi @Audit_CKGoC
Did you have a look there ?
Day-of-year for today:
FLOOR(TOTALHOURS(TODAY() - DATE("1/1/" & YEAR(TODAY()))) / 24),
Number of days in this year:
FLOOR(TOTALHOURS(DATE("1/1/" & (YEAR(TODAY()) + 1)) - DATE("1/1/" & YEAR(TODAY()))) / 24)
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |