ExcelBanter - View Single Post

did you test

--
Don Guillett
SalesAid Software

"Michael Glenn" wrote in message
...
If A1 contains your first date, put this formula in the other cell :
=A1+DATE(0,10,0)

"Help with Date!" wrote:

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