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.
Bookmarks