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

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

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

Using EDATE function from Analysis ToolPak add-in

=EDATE(A1,10)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515750

=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

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

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

If he uses =A1+DATE(0,11,0) it sorta works :-)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Don Guillett" wrote in message
...
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

Quite right! I do apologize...gave the correct result on the first try so I
didn't test further...DO NOT USE MY FORMULA!

"Don Guillett" wrote:

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

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

Adding DATE(0,10,0) is the same as adding 274. About 9 months, depending on
when you add and whether it is a leap year or not.

"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

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

So, in Excel, when you ask- How do I add 10 months to a date? The answer is,
it depends on which 10 months you want to add...

It depends upon what the date you want to add to is. Personally, I would
never add 10 months by adding DATE(0,10,0) because that is 274 days, not 10
months.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dlw" wrote in message
...
So, in Excel, when you ask- How do I add 10 months to a date? The answer
is,
it depends on which 10 months you want to add...