|
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 |
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 |
Help with Date!
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 |
Help with Date!
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 |
Help with Date!
=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 |
Help with Date!
|
Help with Date!
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 |
Help with Date!
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 |
Help with Date!
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 |
Help with Date!
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 |
Help with Date!
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 |
Help with Date!
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 |
Help with Date!
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... |
Help with Date!
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... |
| All times are GMT +1. The time now is 03:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com