Convert days to year

[jochendecraene]

Hi

I used this code to calculate the difference between 2 dates 

Duration.Days(Duration.From([Date_Today]-[Date]))

This gives me the proper result in days, but can I convert these days into years?

so that ex 65 days  = 0 years, 521 = 1 year ...

thx

[Fowmy · Accepted solution]

@jochendecraene 

Your formula will go as :

Number.RoundDown(
Duration.Days(Duration.From([Date_Today]-[Date]))/365.25,
0
)

[jochendecraene]

@Fowmy Thx

Can you just explain how the formula works?

Thnx!

[Fowmy]

@jochendecraene 

First, calculate the days difference as oer your formula,
Divide it by 365.25 (.25 added to include leap year as it comes once in 4 years), you get the year with fraction.
Round it down to show only full completed year(s).