How to adjust a date based on logic

Question

Here are 2 examples I am looking for a help:

Option A: I want to add a new column C where I would see the same date plus 4 years

Option B: I want to add a new column C where I would see a new date that come from column B plus 2 years and date & month set to January 1

See example below with input in column A&B and desired results in column C

atcodedog05 · Answer

Happy to help : ) @mlozovskaya

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!

mlozovskaya · Answer

That's exactly what I was looking for! Thanks so much!

atcodedog05 · Answer

Hi @mlozovskaya

You can use this formula

IF [Option]="A" 
THEN DateTimeAdd([Old Date],4,"years") 
ELSE 
DateTimeFormat(DateTimeAdd([Old Date],2,"years"),"%Y-01-01")
ENDIF

Workflow:

Hope this helps : )

old and new date.yxmd