Results 1 to 11 of 11

Excel =Date and Leap Years

Threaded View

thesonofdarwin Excel =Date and Leap Years 06-12-2010, 04:06 PM
shg Re: Excel =Date and Leap Years 06-12-2010, 04:10 PM
thesonofdarwin Re: Excel =Date and Leap Years 06-12-2010, 11:43 PM
shg Re: Excel =Date and Leap Years 06-13-2010, 12:20 AM
thesonofdarwin Re: Excel =Date and Leap Years 06-14-2010, 12:06 AM
ConneXionLost Re: Excel =Date and Leap Years 06-14-2010, 01:58 AM
thesonofdarwin Re: Excel =Date and Leap Years 06-14-2010, 07:05 AM
ConneXionLost Re: Excel =Date and Leap Years 06-14-2010, 02:01 PM
thesonofdarwin Re: Excel =Date and Leap Years 06-14-2010, 06:58 PM
daddylonglegs Re: Excel =Date and Leap Years 06-14-2010, 07:41 PM
KeesValkenswaar Re: Excel =Date and Leap Years 06-15-2010, 03:31 AM
  1. #5
    Registered User
    Join Date
    10-13-2009
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    75

    Re: Excel =Date and Leap Years

    For example it counts dates passing through year 2010 (365 days) the same as dates passing through 2012 (366 days).

    2 years on to 2011-01-25 should not be 2013-01-25 as there is an extra day in 2012. Excel doesn't seem to factor this in, however. This function makes it seem like 2011 and 2012 have the same number of days. It is summing the years without any consideration to years it advances through. The only consideration to leap years comes when the final date is generated and it checks to see if that day exists during that year. For example 2008-02-29 + 4 years = 2012-02-29 whereas 2009-02-29 + 3 years = 2011-03-01. That's as far as it takes leap years into consideration. I need it to add a day to the final date for every leap year that is added on to the initial date.
    Last edited by thesonofdarwin; 06-14-2010 at 12:09 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1