KuraiChikara
Board Regular
- Joined
- Nov 16, 2016
- Messages
- 111
- Office Version
- 2013
- Platform
- Windows
Hello,
I have a simple concept that I can't seem to figure out.
I'm trying to simplify a process on how many years have gone by, from a date of purchase of a product, compared to the current date.
Example of a working process: I purchase a server on 03/21/2014, that's RAW data. I can then manually enter todays date 11/17/2020 in another cell (or use a formula), subtract todays date from date of purchase then divide by 365. The end result is correct but I can only figure this process out by having 4 columns when I only want two.
I want to simplify using only two columns; the Date of Purchase column and a column for the formula but I can't figure that out.
I plug in the following formula, which I think mimics the same steps as above, but it doesnt work: =TODAY()-A2/365, in NUMBER format it gives me 44037.70 as a result.
How can I reflect the answer of 6.67 years?
I have a simple concept that I can't seem to figure out.
I'm trying to simplify a process on how many years have gone by, from a date of purchase of a product, compared to the current date.
Example of a working process: I purchase a server on 03/21/2014, that's RAW data. I can then manually enter todays date 11/17/2020 in another cell (or use a formula), subtract todays date from date of purchase then divide by 365. The end result is correct but I can only figure this process out by having 4 columns when I only want two.
Date of Purchase | Manual Entry Todays Date | Subtraction | Division |
03/21/2014 | 11/17/2020 | 2433 (days) | 6.67 (years) |
I want to simplify using only two columns; the Date of Purchase column and a column for the formula but I can't figure that out.
I plug in the following formula, which I think mimics the same steps as above, but it doesnt work: =TODAY()-A2/365, in NUMBER format it gives me 44037.70 as a result.
How can I reflect the answer of 6.67 years?
Date of Purchase | Formula |
03/21/2014 | =TODAY()-A2/365 |