Help with Date!

H

Help with Date!

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
 
D

Don Guillett

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

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

Michael Glenn

If A1 contains your first date, put this formula in the other cell :
=A1+DATE(0,10,0)
 
B

Bob Phillips

=MIN(DATE(YEAR(A1),MONTH(A1)+{11,10},DAY(A1)*{0,1}))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

dlw

why does adding date(0,10,0) come out a day off?

Bob Phillips said:
=MIN(DATE(YEAR(A1),MONTH(A1)+{11,10},DAY(A1)*{0,1}))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
M

Michael Glenn

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

Dave Peterson

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).
 
S

Sloth

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.
 
B

Bob Phillips

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)
 
D

dlw

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...
 
B

Bob Phillips

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)
 
Top