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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lisa" wrote:
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,