# Date Calculation Help

#### KuraiChikara

##### Board Regular
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.
 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

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=(TODAY()-A2)/365``
or
Excel Formula:
``=YEARFRAC(A2,TODAY())``

#### Joe4

Order of operations is important here. You need parentheses:
 Excel Formula: ``=(TODAY()-A2)/365``

#### KuraiChikara

##### Board Regular
Order of operations is important here. You need parentheses:
 Excel Formula: ``=(TODAY()-A2)/365``
Thank you, I know it had to do with the Order of Operations, I just didnt know how to set it up that way.

Replies
2
Views
118
Replies
7
Views
236
Replies
1
Views
48
Replies
6
Views
106
Replies
16
Views
137