Date difference

[SanjayaGarg]

Hello ! I want to calculate difference between start date and end date. While doing so using 'datedif' formula, I am getting result as follows :

A​	B​	C​	D​
Start Date​	End Date​	Result​	Formula​
16-04-2021	15-04-2022	0 Years, 11 Months, 30 Days	IF(A3="","",DATEDIF(A3,B3,"Y")&" Years, "&DATEDIF(A3,B3,"YM")&" Months, "&DATEDIF(A3,B3,"MD")&" Days")

The result should be 1 year as 30 days equal to 1 month and 12 months equal to 1 year.

Please make any correction if possible.

 

[Sufiyan97]

Try

Book1
	A	B	C	D
1
2
3	4/16/2021	4/15/2022	1 Years, 0 Months, 0 Days
4
Sheet1

Cell Formulas
Range	Formula
C3	C3	=IF(A3="","",DATEDIF(A3,B3+1,"Y")&" Years, "&DATEDIF(A3,B3+1,"YM")&" Months, "&DATEDIF(A3,B3+1,"MD")&" Days")

 

[SanjayaGarg]

Try

Book1
	A	B	C	D
1
2
3	4/16/2021	4/15/2022	1 Years, 0 Months, 0 Days
4
Sheet1

Cell Formulas
Range	Formula
C3	C3	=IF(A3="","",DATEDIF(A3,B3+1,"Y")&" Years, "&DATEDIF(A3,B3+1,"YM")&" Months, "&DATEDIF(A3,B3+1,"MD")&" Days")

Thanks. It is working.

 

[Sufiyan97]

You're welcome.