plssss help re formula to calculate next contract term increment from a date based on today's date

[silverandcoldmc]

Hi please can someone try help with a formula that will show current contract term end date , if know the start date (say 1/4/2010) 36 month term, (1/4/2014 ) then annually rolling , ie based on today's date of 29/03/2023 , my current contract would end 1/4/2023. But how to i use a formula to show this . ie current contract end date. i can obs add 1 year each time , but dont know how to get to current year. this and use different start dates that show me contract end date . thanks you in advance

 

[silverandcoldmc]

connection notice date		contract term		intial term date	annually rolling	current contract end date
01/04/2010		36		31/03/2013	yes	31/03/2023​

 

[Sufiyan97]

Hi & Welcome to MrExcel.

I am still not clear with the query, if start date is 31/03/2013 then why is end date 31/3/2023 if term is 36 months.
Wouldn't it be end on 03/31/2016?

 

[silverandcoldmc]

Hi & Welcome to MrExcel.

I am still not clear with the query, if start date is 31/03/2013 then why is end date 31/3/2023 if term is 36 months.
Wouldn't it be end on 03/31/2016?

Hi thanks for responding
Its initial 36 month term then rolls annually so in a “new” term each year

 

[silverandcoldmc]

So something like = if today()> startdate +36 months then new contract end date = today() + something ( i know not used xls language but trying to explain