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

Audit_CKGoC
Participant IV

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

0 2 98
2 REPLIES 2

Aurelien
Participant V

Hi @Audit_CKGoC

Did you have a look there ?

Steve
Participant V

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)
Top Labels in this Space