Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get exact date
Hi!
How to know which date will it be after 5 years from today? Suppose, A1=7-Aug-2005, so what will be the way to know which day and month will it be after 5 yers from the given in date A1? Thanks. Deepak |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get exact date
deepak wrote:
Hi! How to know which date will it be after 5 years from today? Suppose, A1=7-Aug-2005, so what will be the way to know which day and month will it be after 5 yers from the given in date A1? Thanks. Deepak Your question suggests "7 August" might not be correct. What result are you expecting? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get exact date
deepak wrote:
Hi! How to know which date will it be after 5 years from today? Suppose, A1=7-Aug-2005, so what will be the way to know which day and month will it be after 5 yers from the given in date A1? Thanks. Deepak 5 years from August 7, 2005 will indeed still be August 7. However, if you want Excel to calculate this information for you including the year using a function, see Excel help for adding or subtracting years to a date. If you just need the month and the day use the day and month function. Bill |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get exact date
bill wrote:
5 years from August 7, 2005 will indeed still be August 7 well, maybe not. if those 5 years contained one leap year, August 7 would now be August 8, wouldn't it? and if that 5 years encompassed 2 leap years, 5 years would make it August 9th. or am i just blowing steam? susan On Oct 16, 12:22*pm, Bill Sharpe wrote: deepak wrote: Hi! How to know which date will it be after 5 years from today? Suppose, A1=7-Aug-2005, so what will be the way to know which day and month will it be after 5 yers from the given in date A1? Thanks. Deepak 5 years from August 7, 2005 will indeed still be August 7. However, if you want Excel to calculate this information for you including the year using a function, see Excel help for adding or subtracting years to a date. If you just need the month and the day use the day and month function. Bill |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get exact date
5 years on from 7 Aug 05 will still be 7 Aug.
-- David Biddulph Susan wrote: bill wrote: 5 years from August 7, 2005 will indeed still be August 7 well, maybe not. if those 5 years contained one leap year, August 7 would now be August 8, wouldn't it? and if that 5 years encompassed 2 leap years, 5 years would make it August 9th. or am i just blowing steam? susan On Oct 16, 12:22 pm, Bill Sharpe wrote: deepak wrote: Hi! How to know which date will it be after 5 years from today? Suppose, A1=7-Aug-2005, so what will be the way to know which day and month will it be after 5 yers from the given in date A1? Thanks. Deepak 5 years from August 7, 2005 will indeed still be August 7. However, if you want Excel to calculate this information for you including the year using a function, see Excel help for adding or subtracting years to a date. If you just need the month and the day use the day and month function. Bill |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get exact date
Susan wrote:
bill wrote: 5 years from August 7, 2005 will indeed still be August 7 well, maybe not. if those 5 years contained one leap year, August 7 would now be August 8, wouldn't it? I think you meant August 6, right? August 7 + 365 days lands on August 6 when a leap day is in the midst. and if that 5 years encompassed 2 leap years, 5 years would make it August 9th. August 5? or am i just blowing steam? susan It all depends on your definition of "year". One "year" from now, or two, or ten, my birthday will be on the same day. I never think of it being "a year and a day" away when a leap day is included. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get exact date
On Fri, 16 Oct 2009 11:29:27 -0700 (PDT), Susan wrote:
bill wrote: 5 years from August 7, 2005 will indeed still be August 7 well, maybe not. if those 5 years contained one leap year, August 7 would now be August 8, wouldn't it? and if that 5 years encompassed 2 leap years, 5 years would make it August 9th. or am i just blowing steam? susan Well, you're defining your own calendar. A calendar year is generally defined as having 365 or, if a leap year, 366 days. It can also be defined as the length of time it takes a planet to orbit its sun. In the case of the earth, that is approximately 365 days 6 hours 9 minutes 9.54 seconds. That's why we have leap years (and the occasional leap second), in order to bring the calendar back in sync with the earth's rotation. So how do you want to define your year? If you want to define a year so that anniversaries, birthdays, and so forth will be celebrated on the proper date, then: 5 years from Aug 7, 2005 would be Aug 7, 2010 And the excel formula would be: =MIN(DATE(YEAR(A1)+5,MONTH(A1)+{1,0},DAY(A1)*{0,1} )) On the other hand, if you want to define a year differently, you'll have to clearly state your definition in order to derive a formula. --ron |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get exact date
Susan wrote:
bill wrote: 5 years from August 7, 2005 will indeed still be August 7 well, maybe not. if those 5 years contained one leap year, August 7 would now be August 8, wouldn't it? and if that 5 years encompassed 2 leap years, 5 years would make it August 9th. or am i just blowing steam? susan Using your reasoning, our birthdays would change every four years (for the most part -- 2000 was a leap year, but 2100 will not be). And, of course, those born on February 29 only get to celebrate every four years. <g A year is not defined as 365 days. It's not nearly that simple, as another poster has pointed out. Bill |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
To get exact date
ok, i get it. weird thought - blame it on friday.
:) susan On Oct 18, 3:37*pm, Bill Sharpe wrote: Susan wrote: bill wrote: 5 years from August 7, 2005 will indeed still be August 7 well, maybe not. *if those 5 years contained one leap year, August 7 would now be August 8, wouldn't it? and if that 5 years encompassed 2 leap years, 5 years would make it August 9th. or am i just blowing steam? susan Using your reasoning, our birthdays would change every four years (for the most part -- 2000 was a leap year, but 2100 will not be). And, of course, those born on February 29 only get to celebrate every four years. <g A year is not defined as 365 days. It's not nearly that simple, as another poster has pointed out. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To get exact Date | Excel Discussion (Misc queries) | |||
Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
Line Chart-EXACT End Date | Charts and Charting in Excel | |||
How to get the Excel to calculate the exact date from a given date | Excel Worksheet Functions | |||
Sorting by date when the date isn't exact | Excel Discussion (Misc queries) |