Because Date(0,10,0) is the 30th Sep 1900, which is day 274, so adding 274
days will be a number of days off, depending upon where the start month is,
because 10 months from a given date may be 273 days, may be 275, may even be
276 (as in my test).

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dlw" wrote in message
...
why does adding date(0,10,0) come out a day off?

"Bob Phillips" wrote:

=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