To get exact date

D

deepak

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
 
S

smartin

deepak said:
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
Click to expand...

Your question suggests "7 August" might not be correct. What result are
you expecting?
 
B

Bill Sharpe

deepak said:
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
Click to expand...

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
 
S

Susan

bill said:
5 years from August 7, 2005 will indeed still be August 7
Click to expand...

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
 
S

smartin

Susan said:
well, maybe not. if those 5 years contained one leap year, August 7
would now be August 8, wouldn't it?
Click to expand...

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.
Click to expand...

August 5?

or am i just blowing steam?
susan
Click to expand...

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

Ron Rosenfeld

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
Click to expand...

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
 
B

Bill Sharpe

Susan said:
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
Click to expand...
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
 
Top