=MIN(DATE(YEAR(A1),MONTH(A1)+{11,10},DAY(A1)*{0,1} ))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Help with Date!" <Help with wrote in
message ...
I would like to know to connect a date with another date.

This is what I need help with:
I want to have two columns where I in the first one can type in today's
date. In the column right beside it I want a column with a date that
counts
forward (say 10 months) from today's date.

Ex: I type in the following date in the first column; 2006-01-01.
In the second column I want it to say 2006-10-01.

Is there anyone who can help me with my problem!

Thankfully