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!