The zeroeth day of a month is the last day of the previous month.

Excel is very smart when it comes to dates. The zeroeth day of the year
(January 0th, 2006), is the last day of the previous year (Dec 31, 2005).



dlw wrote:

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




--

Dave Peterson