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]

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

[Aurelien]

Hi @Audit_CKGoC

Did you have a look there ?

Convert Birthdate to Current Age in Years/Months format Tips & Tricks 💡

Calculating the current Age based on a date-of-birth column: [48%20AM] Formula FLOOR(HOUR(TODAY()-[DOB])/365/24)&" yr "& FLOOR(MOD((HOUR(TODAY()-[DOB])/24),365)*12/365) & " mo" Line 1 HOUR(TODAY()-[DOB]) returns the number of Hours in the duration /365/24 converts hours to years, and FLOOR gives the number of full years, dropping the decimal. Line 2 (HOUR(TODAY()-[DOB])/24) returns the number of days in the duration MOD((...),365) finds the remainder in days, after removing the …

[Steve]

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)