calculate the difference between two dates all in one cell

[happydz]

Hi guys
I need to calculate the difference between two dates (Days/Months/Years) all in one cell, I tried the formula as shown in the screenshot, but it faild.
I have microsoft office excel 2007
I tried every trick I found on youtube, but none of them worked
It would be very helpful if you create a completed template (excel sheet.xls) so that I will find it easier to edit the dates
thank you in advance

 

[Fluff]

Looks like you're missing a closing ) try
=IF(DATEDIF(A24,B24,"y")=0,"",DATEDIF(A24,B24,"y")&" Years")&IF(DATEDIF(A24,B24,"ym")=0,"",DATEDIF(A24,B24,"ym")&" Months")&IF(DATEDIF(A24,B24,"md")=0,"",DATEDIF(A24,B24,"md")&" Days")

 

[happydz]

it did not work

 

[Fluff]

Works for me

Excel 2013 32 bit
	A	B	C
1	04/05/2001	04/06/2015	14 Years 1 Months
2	04/05/2001	06/06/2015	14 Years 1 Months 2 Days
3	04/05/2015	07/06/2015	1 Months 3 Days
Sheet1

Cell Formulas
Range	Formula
C1	=IF(DATEDIF(A1,B1,"y")=0,"",DATEDIF(A1,B1,"y")&" Years ")&IF(DATEDIF(A1,B1,"ym")=0,"",DATEDIF(A1,B1,"ym")&" Months ")&IF(DATEDIF(A1,B1,"md")=0,"",DATEDIF(A1,B1,"md")&" Days ")

 

[happydz]

no luck, it did not work
here's the screenshot

 

[happydz]

I changed from standard to date too, but unfortunately no luck

 

[Fluff]

Ok, lets break it down
in D1 put =DATEDIF(A1,B1,"y")
in E1 put =DATEDIF(A1,B1,"ym")
in F1 put =DATEDIF(A1,B1,"md")
What do you get?

 

[happydz]

Ok, lets break it down
in D1 put =DATEDIF(A1,B1,"y")
in E1 put =DATEDIF(A1,B1,"ym")
in F1 put =DATEDIF(A1,B1,"md")
What do you get?

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[/TR]
[TR]
[TD]28-10-17[/TD]
[TD]17-11-17[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
P.S: F1 the result should be (20 days) not (19 days)

 

[happydz]

can you pm the complete worksheet, please

 

[Fluff]

?? I Get 20 days
what if you use these dates
04/05/2001 06/06/2015