How to add year based on particular date

[Anuj_1196]

ValDate	30/08/2023
	relative period	Want
LFY	0	30/06/2023
FY+1	1	30/06/2024
FY+2	2	30/06/2025
FY+3	3	30/06/2026
FY+4	4	30/06/2027
FY+5	5	30/06/2028
5YR CAGR/Average 5YR	6	30/06/2199
TY	7	30/06/2200

[ShankerV]

Hi @Anuj_1196 

Please make use of the datetimeadd() function to get the desired output.

Many thanks

Shanker V

[Anuj_1196]

Thanks for your time. Unfortunately, I couldn't achieve desire output with datetimeadd().

[ShankerV · Accepted solution]

Hi @Anuj_1196 

One way of doing this.

datetimeformat(DateTimeAdd(datetimeparse([ValDate],"%d/%m/%y"),[Relative Period],"year"),"%d/%m/%Y")

Many thanks

Shanker V

[Anuj_1196]

Thanks for the help. I tried using Multi Row Formula and it worked.