Calculate Due date after every alternate year from a start date

Hello,

I would appreciate if someone could help me in calculating due date every alternate year from a start date.

Example:

Mr. A will travel to USA every alternate year, means if his first travel is on 01/01/2013 his next travel will be on 01/01/2015. I need this to be automated using any formula in excel 2007.

Please help

Best Regards,
Dada

Hi JieJenn,

Output in B1 is 01/01/2015, as data in A1 is 01/01/2013. When I drag it down, same output in B1 is repeated. This is not the result I am looking at. Please look into the given scenario:

I have to maintain a data travel date for 50 people whose subsequent travel dates depends on respective first travel date. If Mr. A's first travel date is on 01/01/2010, his next travel date will be 01/01/2012; if B's first travel date is on 01/05/2011, his next travel date will be 01/01/2013; if Mr C's first travel date is on 01/12/2012, his next travel date will be 01/12/2014, and so on...

Hope now its clear...please suggest

Best Regards,
Dada

attached is the sample data

Hi,

Appreciate if someone could help me to calculate this due date. Please..

thanks,
Dada

Hi,

I modify little bit