Add partial year to date
On Mon, 21 May 2012 14:05:47 +0000, glyndwr99 wrote:
Hello, I'm trying to add 6.75 years to a date in Excel and I think I'm
close, but I don't like the 365.26 usage for years..
Here is what I have
=DATE(YEAR(A1)+6, MONTH(A1),DAY(A1) + 273.945 )
Where A1 = 1/1/1960.
And 273.945 = 365.26 *.75 (use 365.26 for average number of days in a
year)
But it spits out 10/1/1966... while that may be right, how do I get the
exact date? Thanks!
Since a year can be either 365 or 366 days, 6.75 years is not clearly defined and will vary depending on the included number of leap years in the range. So unless you can precisely define what you mean by 3/4 of a year, your convention of using 365.26 * 0.75 is close, although I would use 365.24 or 365.245 (average number of days/year over 200 years) or 365.25 (average number of days/year over 4 years)
And, if 10/1/1966 is not an "exact date", what do you mean by an "exact date"?
|