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

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?

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

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

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

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.

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

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

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