Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=IF(YM.YEAR_1=2017,'2016-17',
IF(YM.YEAR_1=2018,'2017-18',
IF( YM.YEAR_1=2019,'2018-19',
IF(YM.YEAR_1=2020,'2019-20',
IF(YM.YEAR_1=2021,'2020-21',
IF(YM.YEAR_1=2022,'2021-22',
)
)
)
)
)
)
or you can use pic match function also.
This seems to be posted on the wrong thread
@venkat1 what product are you using?