How to calculate the difference between two dates for only one time?

[happydz]

How to calculate the difference between two dates so that the result comes up as just as only number of days less than 7 days or weeks less than 4 weeks or months less than 12 months or just number of years. To make it clear, I have this example (1):
Let's assume that the old date is 25/05/2022 and the recent date is 28/05/2022 so the result will be 0 years, 0 months, 3 days. but I want the result to show only 3 days instead of displaying the 0 years, 0 months.
Example (2): old date is 07/05/2022 - recent date is 28/05/2022. the result will be 0 years, 0 months, 3 weeks. but I want the result to show only 3 weeks instead of displaying the 0 years, 0 months.
Example (3): old date is 19/4/2022 - recent date is 28/05/2022. the result will be 0 years, 0 months, 5 weeks, 4 days. but I want the result to show only 1 month instead of displaying the 0 years, 5 weeks, 4 days.
Example (4): old date is 10/05/2021 - recent date is 28/05/2022. the result will be 1 years, 1 months, 0 weeks, 9 days. but I want the result to show only 1 year instead of displaying 1 years, 1 months, 0 weeks, 9 days

I need a formula to use in column C as date difference if the column A is relating to the old date and B is relating to the recent column.

I hope these examples make it clear for you to help me.

Social Media Accounts.xlsx
	A	B	C	D	E
1	5/25/2022	5/28/2022
2	5/7/2022	5/28/2022
3	4/14/2022	5/28/2022
4	5/10/2021	5/28/2022
Feuil7

 

[bebo021999]

Book1
	A	B	C
1	25/05/2022	28/05/2022	3 days
2	07/05/2022	28/05/2022	3 weeks
3	19/04/2022	28/05/2022	1 month
4	10/05/2021	28/05/2022	1 year
Sheet1

Cell Formulas
Range	Formula
C1:C4	C1	=IF(DATEDIF($A1,$B1,"y")>0,DATEDIF($A1,$B1,"y") & " year" & IF(DATEDIF($A1,$B1,"y")>1,"s",""),IF(DATEDIF($A1,$B1,"m")>0,DATEDIF($A1,$B1,"m")&" month"&IF(DATEDIF($A1,$B1,"m")>1,"s",""),IF(DATEDIF($A1,$B1,"d")>6,INT(DATEDIF($A1,$B1,"d")/7)&" week" & IF(DATEDIF($A1,$B1,"d")>13,"s",""), DATEDIF($A1,$B1,"d") & " day" & IF(DATEDIF($A1,$B1,"d")>1,"s",""))))

 

[happydz]

Book1
	A	B	C
1	25/05/2022	28/05/2022	3 days
2	07/05/2022	28/05/2022	3 weeks
3	19/04/2022	28/05/2022	1 month
4	10/05/2021	28/05/2022	1 year
Sheet1

Cell Formulas
Range	Formula
C1:C4	C1	=IF(DATEDIF($A1,$B1,"y")>0,DATEDIF($A1,$B1,"y") & " year" & IF(DATEDIF($A1,$B1,"y")>1,"s",""),IF(DATEDIF($A1,$B1,"m")>0,DATEDIF($A1,$B1,"m")&" month"&IF(DATEDIF($A1,$B1,"m")>1,"s",""),IF(DATEDIF($A1,$B1,"d")>6,INT(DATEDIF($A1,$B1,"d")/7)&" week" & IF(DATEDIF($A1,$B1,"d")>13,"s",""), DATEDIF($A1,$B1,"d") & " day" & IF(DATEDIF($A1,$B1,"d")>1,"s",""))))

thank you for the formula, but the thing is that I have French excel and all the computers in my country are French systematic , so I'd be grateful if you can give me or rather transform the formula to work with French excel.

 

[happydz]

thank you for the formula, but the thing is that I have French excel and all the computers in my country are French systematic , so I'd be grateful if you can give me or rather transform the formula to work with French excel.

=SI(DATEDIF($A1;$B1;"y")>0;DATEDIF($A1;$B1;"y") & " year" & SI(DATEDIF($A1;$B1;"y")>1;"s";"");SI(DATEDIF($A1;$B1;"m")>0;DATEDIF($A1;$B1;"m")&" month"&SI(DATEDIF($A1;$B1;"m")>1;"s";"");SI(DATEDIF($A1;$B1;"d")>6; ENT (DATEDIF($A1;$B1;"d")/7)&" week" & SI(DATEDIF($A1;$B1;"d")>13;"s";""); DATEDIF($A1;$B1;"d") & " day" & SI(DATEDIF($A1;$B1;"d")>1;"s";""))))