Hi everyone, Good day
I am looking to create a formula that calculates the difference between two years (e.g., 2024 and 2020, which would give a difference of 4 years). I have searched for relevant examples in the use cases, but I couldn’t find one that matches my specific need.
Could anyone kindly help me with the correct formula to achieve this?
Thank you in advance for your assistance!
You could try this:
ABS({year1} - {year2})
If the dates are in the format dd/mm/yyyy (e.g., 25/12/2024 and 25/12/2020), you’ll first need to extract the year portion from these date strings before calculating the difference.
ABS(YEAR({date1}) - YEAR({date2}))
Let me know if this works.
————
Formula PRO: Advanced Automations for native monday formula columns, Mirror Columns & Subitems!
Find it on the monday app marketplace.
Hi @hellotimi,
Thanks for the suggestion! The method you provided works perfectly. I was able to extract the year portion from the dates using “YEAR({date1})” and “YEAR({date2})”, and the calculation of the difference using “ABS” is giving me the correct result. Appreciate the help!
That’s great to hear that it worked. If you can mark my previous response as a solution, I’d appreciate that.
—————
I hope you don’t mind a bit of self promotion 
If you ever need to use more functions than the formula column provides or you need to use the formula column results in your automations or project the results of formula calculations to other columns (incl item names), mirror columns, subitems, I built an app called formula pro that allows you to do all that and more. You can find it on the monday marketplace or the link in my previous reply.