Thread: Help with Date!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Help with Date!

This is NOT a dating service. Goto msnews.public.dating.fr
In the meantime, try this:

=DATE(YEAR(G3),MONTH(G3)+10,DAY(G3))

--
Don Guillett
SalesAid Software

"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