I am working with this data in excel. here is the original data

Please Login or Register  to view this content.
I would like to use an excel function to find the year interval for the each person. I have shown my input file and output file. I can't think of anything right now, any ideas?

many thanks in advance.