Date Calculation Help

KuraiChikara

Board Regular
Joined
Nov 16, 2016
Messages
111
Office Version
  1. 2013
Platform
  1. 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.
Date of PurchaseManual Entry Todays DateSubtractionDivision
03/21/201411/17/20202433 (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 PurchaseFormula
03/21/2014=TODAY()-A2/365
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
How about
Excel Formula:
=(TODAY()-A2)/365
or
Excel Formula:
=YEARFRAC(A2,TODAY())
 
Upvote 0
Order of operations is important here. You need parentheses:
Excel Formula:
=(TODAY()-A2)/365
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,528
Messages
6,114,154
Members
448,553
Latest member
slaytonpa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top