How to get difference between 2 dates in days/months/years
Cell1 contains date 1 (dd/mm/yyyy)
Cell2 contains date 2 (dd/mm/yyyy)
Cell3 difference between Cell1 and Cell2 in number of years-months-days like (45-06-22)
The above is required for calculating the age of a person exactly.
Please suggest solution
Thanks in Advances
NRMDU
22.11.2015
do you want this?
=DATEDIF(A1,A2,"y") & " -" & DATEDIF(A1,A2,"ym") & " - " & DATEDIF(A1,A2,"md")
Last edited by ImranBhatti; 11-22-2015 at 12:00 PM.
If A2 = todays date
B2 = Birth day
then Years
Formula:
Please Login or Register to view this content.
Months
Formula:Please Login or Register to view this content.
Days
Formula:Please Login or Register to view this content.
But simpler solutionFormula:Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
This makes the calculation the way you describe only the single digits are not preceded by a 0
Formula:Please Login or Register to view this content.
To give Years, Months and Days
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks