Today's date minus certain date

Hello, folks!

I have a certain date in one cell:
Capture.PNG

How to make the excel reflect the difference between today's date and that certain date in years months and days?
So it would be =today's date-certain cell

Thank you!

.
If your dates are in Row 1 ... paste the following in A2, then drag over to D2:

Please Login or Register  to view this content.

The result is :

	A	B	C	D
1	8/5/17	8/15/17	8/28/17	8/12/17
2	0 years,3 months,12 days	0 years,3 months,2 days	0 years,2 months,20 days	0 years,3 months,5 days

Originally Posted by Logit

.
If your dates are in Row 1 ... paste the following in A2, then drag over to D2:

Please Login or Register  to view this content.

The result is :

	A	B	C	D
1	8/5/17	8/15/17	8/28/17	8/12/17
2	0 years,3 months,12 days	0 years,3 months,2 days	0 years,2 months,20 days	0 years,3 months,5 days

Sorry, do not understand what exactly you meant here.
When I copy the code you gave and paste it to the cell, nothing happens, excel does not take it as a code.

What exactly should I do here?
Sorry for my ignorance.

Review the attached :

Originally Posted by Logit

Review the attached :

Thank you for your informative answer!
I just only needed to replace ; with commas!

Thank you!!

.
You are welcome.