How to add more years to a format date mm/dd/yyyy?

[DE22]

Hello, 

Could you, please help me with this topic, I want to add more years to a start date. 

Start date/Trade date (mm/dd/yyyy)         Years to add
01/31/2025                                                   5

In the end, i want to have the date like this: 01/31/2030. 

Thank you!

[JosephSerpis · Accepted solution]

Hi @DE22 you need to parse the date as it's not in ISO format YYYY-MM-DD and use the formula date time add. Then use datetime format to change into your desired format. It's a few steps but can be done inside a single formula tool. 

[DE22]

Thanks a lot! It really helped :p