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

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)
5 Likes