Calculate years between two date columns

Hi! Im trying to calculate the amount of years between two date columns.
Example: Date1: 25/2/2019 - Date2: 25/2/2021 - Outcome: 2.
I found a similar formula, but for hours (HOURS_DIFF).
I apologize if this subject has already been posted, if so, I wasn´t able to locate it.
Thanks in advance!

@marcos.smart,

Try:

ROUND(Days({Date2},{Date1})/365.24,0)

See:
Function: DAYS
Description: Returns the number of days between the two dates
Example:DAYS({end date column name}, {start date column name}) => diff between dates in days

From: List of all available formulas – Support

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.