cancel
Showing results for
Did you mean:
Helper III

## Convert days to year

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

1 ACCEPTED SOLUTION
Super User

@jochendecraene

Your formula will go as :

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
3 REPLIES 3
Super User

@jochendecraene

Your formula will go as :

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
Helper III

@Fowmy Thx

Can you just explain how the formula works?

Thnx!

Super User

@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).

Did I answer your question? Mark my post as a solution! and hit thumbs up

Announcements