Forum Discussion
Solved
Datedif function for duplicates
Hi I'm trying an excel formula for the below. I need to find the difference of the highlighted dates for each ID in months. Thank you
| ID | Start Date | End Date |
| 1 | 5/1/2022 | 1/31/2023 |
| 1 | 6/1/2022 | 1/31/2023 |
| 2 | 6/1/2022 | 2/28/2023 |
| 2 | 9/1/2022 | 2/28/2023 |
Which version of Excel do you use? MAXIFS is available in Office 2019, Office 2021 and Microsoft 365.
If you have an older version, try the following formula, confirmed by pressing Ctrl+Shift+Enter:
=DATEDIF(MAX(IF($A$2:$A$100=A2, $B$2:$B$100)), C2, "m")
6 Replies
In D2:
=C2-MAXIFS($B$2:$B$100, $A$2:$A$100, A2)
Adjust the ranges if you have more than 100 rows of data.
HansVogelaar Thank you - Is it possible to get the difference of the dates in months? right now it gives me a 0. For eg for ID 1 I want cell D2 to show 6
