Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To get exact Date | Excel Discussion (Misc queries) | |||
Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
Line Chart-EXACT End Date | Charts and Charting in Excel | |||
How to get the Excel to calculate the exact date from a given date | Excel Worksheet Functions | |||
Sorting by date when the date isn't exact | Excel Discussion (Misc queries) |