To get exact date

  • Thread starter Thread starter deepak
  • Start date Start 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
 
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
 
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
 
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
 
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
 
Back
Top