How to create a new table using another table but have the date 6 months ahead

[Vis26]

Hello, I want to create a new table based off another one, grabbing all the same data but for the date I want it to be 6 months ahead and if possible, have the ID have a "-ND" added to the end of it. Example added below of the desired output of the new table. Any help is appreciated. Thank you!

Table1

ID	Date	Bonus
1	1/1/2024	$60
2	3/1/2024	$20

Table2 (New Table)

ID	Date	Bonus
1-ND	7/1/2024	$60
2-ND	9/1/2024	$20

[Ahmedx · Accepted solution]

pls try this

[Vis26]

Thank you, that worked!