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