Calculate years between two date columns

Platform discussions
1

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!

1 Like
2

@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: https://support.monday.com/hc/en-us/articles/360001276465-List-of-all-available-formulas

2 Likes
3

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