Year Month Calculation on TODAY ()

Hello Guru's

Looking for your expert advice on how to achieve the following scenario of calculating the number of Year’s & Months from TODAY() until next lot of Long Service Leave (LSL) will be available.

There are 2 parts to this scenario:

LSL is available after 10years from commencement date

Additional 9days LSL for every year after 10yrs based on commencement date

I’ve came up with an extremely hack work-around for both steps above, which is still not providing me with required results:

Step 1)

From my table “CurrentEmployee”, I’ve split [Commencement Date] to DDMM and then included 2019 to it

I created a second table for employee’s that are under 10years, adding [Year] + 10 to commencement date

Then merged the 2 fields together providing existing LSL & upcoming LSL

Step 2)

I applied a new column with the following:

DaysLSL =

VAR Months = DATEDIFF(TODAY(),[MergedField],MONTH)

VAR Years = ROUNDDOWN(Months/12,0)

RETURN CONCATENATE(CONCATENATE(Years, “.”),Months-(Years*12)))

Which gives me the desired result, unless the date is prior to TODAY (re YMResult)

Greatly appreciate any assistance on a way to get desired result