Converting YEARS and MONTHS to decimal

[janema]

Hello, I am trying to convert the years and months between a date and TODAY into a decimal, but my result is coming back off. I am using the following formula, but it should be returning something like 1.11, but it comes back as 24.00 as shown in that first row. I am not sure why my formula isn't coming back correctly. Thank you so much in advance for your help!

=INT(YEARFRAC(L2,TODAY()))*12

 

[myall_blues]

From 27/2/2022 to today is about 2.6 years (not 1.11).
Your formula is calculating that, but then you are taking the integer (which makes it 2) and then multiply by 12 which then equals 24.

To just get 2.6 you only need

=YEARFRAC(L2,TODAY())

 

[janema]

From 27/2/2022 to today is about 2.6 years (not 1.11).
Your formula is calculating that, but then you are taking the integer (which makes it 2) and then multiply by 12 which then equals 24.

To just get 2.6 you only need

=YEARFRAC(L2,TODAY())

Thank you so much!