help with datedif function

[Souled]

hello everyone

i've tried to combine dates together without any dups and i was wondering if anyone could help me

i've added an attachment as an example for what i'm trying to do

thank you in advance

[Beamernsw]

Hi, I've put some formulae in the yellow cells. Hopefully you can make them work for you, I got confused as to which dates you were using.

[Souled]

hi thanks for your efforts, i'm trying to use the earilest date with the latest date without any gaps in the middle as you can see from the first example: between 03/07/1994 to 04/03/2022 there is a total of 27 years and 1 month
my problem comes when there is a gap in the data or duplicates

[AliGW]

@Beamernsw

Administrative Note:

Please include formulae used in your post in addition to providing a workbook (for the benefit of members unable to download attachments).

Thanks.

@Souled

You have marked the thread as solved - is it? Your thread title could have been more detailed - please include what your objectives are in future.