| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Add partial year to date
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Month and year from Cell containing date, month, year & time | Excel Worksheet Functions | |||
| Determine year over year date for comparison | Excel Worksheet Functions | |||
| Partial Year Adjustments (Mod Function) | Excel Worksheet Functions | |||
| How do you compute partial year depreciation using DDB, SYD, SLN,V | Excel Worksheet Functions | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
Threaded Mode
