Hello All,
I’m currently trying to build an effective date for Merit increases and my input is as follows dimensioned by country and year.

Right now, I’m trying to populate the table below with the month of the year e.g. FY23 should should December. I tried writing a formula TIMEDIM(ASM_Input_Merit Date, Month) and convert the data by Month.Month of the Year but it doesn’t work.

Any suggestions on how I should write this formula?