DatedIf Formula help

[Sunshine8790]

I have the below formula to help me calculate years for the current month based on a date in K2.
How can I modify this to reflect a new need?
I don't need it for current month anymore, I need to show how many years based on L2 (which contains only the year of the full date) for next year.

For example:
If the date in L2 is 2024, I need K2 to say "1".
If the date in K2 is 2015, I need K2 to say "10"

=IFERROR(DATEDIF(K2,EOMONTH(NOW(),0),"Y"),"Inactive")

Help appreciated

 

[Asbestos_Jen]

I don't think you need a DATEDIF here, just subtraction. If K2 is a date and L2 is a year only, then try this:

=IFERROR(L2+1-YEAR(K2),"error message")

and replace "error message" with whatever text you'd like if the formula errors.

 

[Sunshine8790]

I don't think you need a DATEDIF here, just subtraction. If K2 is a date and L2 is a year only, then try this:

=IFERROR(L2+1-YEAR(K2),"error message")

and replace "error message" with whatever text you'd like if the formula errors.

Thank you!

 

[Asbestos_Jen]

You're welcome!