View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default 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