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.
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 | |||||||
