Auto date for contracts

G

Guest

I need to have someone enter the contract terms in years/months and the start
date and excel to come up with the full details.

i.e. Start date End Date
11/01/2006 10/31/2007
11/01/2007 11/01/2008
etc...

Is there a formula to do this?
Thank you,
 
G

Guest

Assuming start dates (real dates) in A2 down, with contracted years and
months entered in C2 and D2 down, put in B2:
=IF(A2="","",DATE(YEAR(A2)+C2,MONTH(A2)+D2,DAY(A2)))
Copy B2 down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top